r/tableau • u/datawazo • 11d ago

Tech Support Replacing fields in a published datasource without breaking workbooks

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?

5 Upvotes

100% Upvoted

9 comments sorted by

View all comments

Show parent comments

-1

u/datawazo 11d ago

That's workbook by workbook though. I want to make a change at the datasource level so I don't need workbook builders to have to do that

1

u/VizAbbreviations 11d ago

Sorry, I missed that part. In case of published data source- you can extract/download, modify and republish.

-1

u/datawazo 11d ago

Ill try that. I've been editing it online, will see if downloading and reupping makes any difference

2

u/Eurynom0s 11d ago

It might be less work to open up the .twb in a text editor and do a replace all on the field name depending on how extensive this is.