cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
therealomacoder
Helper I
Helper I

How to rename a table in the model without impacting existing reports in Power BI Service

My tables have started to change purposes (actually views on SQL Server using DirectQuery).

But I've found that if I rename them in the model, all visualizations that used those objects now break.

 

How do I successfully rename a table in a model without breaking all associated visualizations?

1 ACCEPTED SOLUTION
TeigeGao
Solution Sage
Solution Sage

Hi @therealomacoder ,

Based on my test, when we change the dataset tables name in PowerBI desktop, the visual will not be affected, then we can re-publish it to PowerBI Service.

Best Regards,

Teige

View solution in original post

2 REPLIES 2
TeigeGao
Solution Sage
Solution Sage

Hi @therealomacoder ,

Based on my test, when we change the dataset tables name in PowerBI desktop, the visual will not be affected, then we can re-publish it to PowerBI Service.

Best Regards,

Teige

View solution in original post

I don't believe this is the solution. I am looking for a similar answer as the starter of this topic. We have Power BI datasets running in the online service on which multiple reports are reliant.

 

When we change one table name, the measures in the report stop working and all reports crash. If someone can help how to adjust table names in the model without impacting all reports reliant on this model, that would be awesome. Somehow Power BI seems to make the connection between measure and table based on the user interface naming. I think this is bad. Models can grow and need to be adjusted. This will also lead to different measure grouping and therefore table name changes. This seems now impossible it seems or I overlook something. Thanks in advance.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.