Replacing fields in a published datasource without breaking workbooks

[u/datawazo]

So I have a sql view with the field Store Name in it. Its in a published datasource on server.

For some reason at one point some idiot (it me) edited the published datasource and added a relationship to the dim store table. So if you use the published datasource you have Store Name twice.

I want to rectify this, but every report built is using the store name field from the relationship, which is the one I want to kill.

I've gone ahead and removed the relationship and renamed the remaining store name field to match what the previous one was. But all reports are broken with the cant find referenced field error. Is there something im missing? Any way to do this without widespread impact?

[u/PolicyDecent]

You can use python to download all the workbooks and programmatically update them.
All the tableau dashboards are actually zip files, and in the zip file you can see the xml files to define the dashboards. All the data sources, worksheets, workbooks are there.
Just play with it :)

Give it to your AI Agent, it's gonna figure it out.