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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! 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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

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.

Top Solution Authors
Top Kudoed Authors