Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
cainr6
Regular Visitor

Power BI Dataset - Model Swap

I have a series of reports that are connected to a power bi semantic model located on the power bi server.

 

I need to update these reports to all point at a different power bi semantic model with the same schema of the underlying data. I am hoping to be able to accomplish this without needing to manually rebuild the visuals in the reports, but just swap datasets. Is there a way to do this with this setup?

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Only if you have individual queries to connect to the semantic model, and only if the output of both models is EXACTLY the same, down to the tiniest letter.  In all other cases switching will result in loss of :  Measures, Groups, Sorts, etc etc.

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

Only if you have individual queries to connect to the semantic model, and only if the output of both models is EXACTLY the same, down to the tiniest letter.  In all other cases switching will result in loss of :  Measures, Groups, Sorts, etc etc.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.