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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.