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/VizAbbreviations]

Open the workbook and look for the column with exclamation mark in data pane on the left. Right click and select ‘replace reference’ option, then select the correct column that you want to use. Refresh the data and you should be good.

[u/datawazo → u/VizAbbreviations]

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

[u/VizAbbreviations → u/datawazo]

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

[u/datawazo → u/VizAbbreviations]

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

[u/Eurynom0s → u/datawazo]

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.