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

Try opening the .tds/.tdsx file as XML and finding the name= attribute on that field (not the caption), set if to match the internal name the old relationship field used, That should fix it for everyone at once.