CODEWITHSUNDEEP
tableau-api
WestCoastProjects
WestCoastProjects

Reputation: 63042

Switch Data Source for Tableau Sheet

Given that Tableau apparently refuses to allow proper editing of the Data Source I have resorted to creating a new one from scratch.

The screenshot shows the situation: the old Data Source "NY FIPS 5" is still being attached to the Worksheet.

enter image description here

The intention is to use the new DataSource usCountyCrimeSummary : however it is unclear ( to me at least) how to disconnect the old Data Source from the existing sheet and then attach the new DataSource to that sheet.

The big surprise was when clicking on Edit Connection it did not allow selecting a different Data Source : instead it went into the properties of the existing Data Source. So then how to switch the Data Source?

Upvotes: 0

Views: 2650

Answers (1)

Bernardo
Bernardo

Reputation: 3318

One thing to note is that switching data sources will change for all sheets connected to that data source. If you only need to change the data source for one sheet out of many, copy that sheet to a new workbook, change it there, then copy it back.

Perhaps your broken data connection needs to be fixed first, but to change a data source go Data > Replace Data Source

Upvotes: 3

Related Questions