As per my understanding Till tableau 9 you need to use separate datasource for each worksheet if you are frequently updating your data source.
Sheet 1--> Datasource 1
Sheet 2--> Datasource 1(Copy)
Sheet 3--> Datasource 1(Copy)(Copy)
You can follow the below process (No need to add Datasource Every time Manually)
Process 1: Either Duplicate the Datasource.
Process 2 : Or copy the data and paste it again.
Thank you for your suggestion!
I'm actually trying to connect to a completely new data file (that has the same format and headers as the existing connected data sources), and then switch just one of several prepared worksheets to use the new datasource. When I try to do this, Tableau tells me that it will switch ALL the worksheets in the workbook to use the new datasource, not just the one worksheet that I want to point to the new datasource. Is there a way to add new datasources, and then switch just one of several pre-built worksheets to point to the new datasource without having ALL the worksheets switch over?
BTW, I'm using Tableau 9.1.2.
We can do that, Is there any that I can contact to look in to that?
I did not find a solution for this problem either.
Currently the only way is to rebuild the worksheet with the new datasource or to duplicate the hole workbook so you can switch in each workbook to a different datasource.
I agree it is not the solution which should be used but hopefully it will be an option in one of the future release.
I have a workaround.
Copy this sheet and past in a new twbx.
Change data source in the new one. Copy from new one to to old one.
This works, thanks!
I still would love if this would be straight forward within the actual Workbook, but till then it works great.