Forum Discussion
Import Models to DirectLake Semantic Models
Our organization is a small startup currently running 10 Power BI semantic models, each built on top of on-premise source tables.
We recently migrated those source tables to a Fabric Lakehouse and want to simplify our architecture by:
Creating one master semantic model on top of the Lakehouse
Repointing the 10 existing reports to this new semantic model
Key Constraints
We cannot afford significant downtime, since these reports are actively used.
We want to avoid rebuilding the reports if possible.
We want to avoid creating additional Lakehouses because we already have a single centralized Lakehouse.
Current Challenge
We explored the Semantic Link Labs migration script, but it requires:
Creating a Power Query template
Building a Dataflow Gen2
Loading the data into a new Lakehouse per model
This would effectively result in 10 additional Lakehouses, which contradicts our goal of maintaining a single centralized Lakehouse architecture.
What We Are Looking For
We are trying to determine the best migration approach that allows us to:
Move from 10 existing semantic models → 1 master semantic model
Repoint existing reports to the new model
Minimize downtime
Avoid duplicating Lakehouses
Keep the architecture clean and maintainable
Questions
Is there a recommended approach in Microsoft Fabric / Power BI to consolidate multiple semantic models into a single master semantic model backed by a Lakehouse?
Can we rebind or repoint reports to the new semantic model without rebuilding them?
Is there a way to reuse the existing Lakehouse tables directly without using Dataflow Gen2 or creating additional Lakehouses?
Are there best practices or tools (e.g., Tabular Editor, XMLA endpoints, dataset rebinding) that would support this migration with minimal disruption?
Hi abhijsrwaaa,
First, I would recommend keeping semantic models seperate, but they can all be made on the same lakehouse. Building one giant semantic model can result in performance issues.
You can rebind reports to different models, the easiest way is to use Power BI Studio in VS Code. You can right click on a report and rebind through the UI:
If you already have your data going into your lakehouse, then you can create a semantic model directly off of those tables, no need to build new ones.
If your data is not flowing already, then you can create a dataflow gen 2 and as long as it outputs with the same columns, point it to your existing tables.
Hope this helps.
3 Replies
- tayloramy
Super User
Hi abhijsrwaaa,
First, I would recommend keeping semantic models seperate, but they can all be made on the same lakehouse. Building one giant semantic model can result in performance issues.
You can rebind reports to different models, the easiest way is to use Power BI Studio in VS Code. You can right click on a report and rebind through the UI:
If you already have your data going into your lakehouse, then you can create a semantic model directly off of those tables, no need to build new ones.
If your data is not flowing already, then you can create a dataflow gen 2 and as long as it outputs with the same columns, point it to your existing tables.
Hope this helps.
- AnonymousNot applicable
Hi abhijsrwaaa,
I would also take a moment to thank tayloramy , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Regards,
Community Support Team.- AnonymousNot applicable
Hi abhijsrwaaa,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.
Regards,
Community Support Team.