-
1. Re: If you edit or refresh the data connections of one sheet in a workbook, does it edit all of the sheets in that workbook?
Dimitri.B Feb 6, 2013 3:58 PM (in response to Scott Buckley)1 of 1 people found this helpfulIf you update the data source for one sheet, all other sheets that use this same data source will automatically be updated.
In other words, when updating data, you need to do it for each data source, not each sheet, i.e. if you have two data sources and 25 sheets, and fresh data is available for both sources - you need to refresh data only twice, one for each source.
As for dashboards, they are collections of sheets - so if sheets get updated, then dashboards containing them will show updated sheets.
-
2. Re: If you edit or refresh the data connections of one sheet in a workbook, does it edit all of the sheets in that workbook?
Scott Buckley Feb 6, 2013 5:56 PM (in response to Dimitri.B)Great - tha's very helpful. Now I'm running into a new problem.
When I go to edit the connection and select a new data source, the "View Data" preview shows the new data I want to import (~5000) rows. When I actually import it and then right-click the connection for "View Data" it shows only Null values. Have you experienced this before? Do you have any suggestion on how to fix this?
Thanks!
-
3. Re: If you edit or refresh the data connections of one sheet in a workbook, does it edit all of the sheets in that workbook?
Dimitri.B Feb 6, 2013 5:59 PM (in response to Scott Buckley)I haven't seen this one before, sounds like a bug. Unless you actually imported all nulls for some reason, i.e. extract filters, etc.
I'd contact Tableau Support with this one.