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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! 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
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors