Changeing the variable/column names in dataset broke all my reports

[Anonymous]

Hi Community,

So we decided to get a correct common nameing convention on all of our datasets that are referring to the same columns in our database. So we removed all the spaces from names of columns inside our dimensions/fact-tables e.g. inside the dimension dim_ContractingParty we changed  "Contracting Party Description" into "ContractingPartyDescription" and everything seemed fine in the datasets. They are still referring to the same naming in our database we only changed the naming in the datasets.

And since everything seemed to be working we published them to our workspace and all the reports created from these datasets broke.

Is there a quick fix for this? Or do we have to recreate all reports (hundreds) or rollback the name changes of the variables/columns?

Thank you very much in advance,

Apat

[d_gosbell · Accepted solution]

---

@Anonymous wrote:

Is there a quick fix for this? Or do we have to recreate all reports (hundreds) or rollback the name changes of the variables/columns?

---

No, there is no quick fix for this. You either recreate/fix all the reports or rollback the name change. Reports linked to shared datasets reference tables and columns by their name, if you change the name you break the reference. The automatic formula fixup when you change names only happens within a single pbix file.