cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Apat
Frequent Visitor

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

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

1 ACCEPTED SOLUTION
d_gosbell
Super User
Super User


@Apat 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.

View solution in original post

1 REPLY 1
d_gosbell
Super User
Super User


@Apat 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.

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!