Forum Discussion
Connected models in Desktop still create separate semantic models when published?
- 1 year ago
Hi Avih ,
Apologies for the inconvenience you're experiencing with the semantic models after publishing. can you try below steps :- When you publish a PBIX connected to another semantic model via Desktop, it still creates its own dataset in the Power BI Service.
- This is expected behavior Power BI doesn't maintain the local semantic model connection during publishing.
- Each of your 3 PBIX files ends up creating its own dataset (semantic model), even if 2 of them were dependent in Desktop.
- To avoid this, publish only the main PBIX file that contains the full data model.
- For the other two PBIX files, open them in Desktop and remove their existing model.
- Then, go to Home > Get Data > Power BI Datasets and connect to the semantic model from the Power BI Service.
- These become “thin reports” that rely on the shared dataset in the Service no duplication of semantic models.
- When you publish the thin reports, only the report is published not another dataset.
- If you edit or extend the model in the dependent PBIX (creating a composite model), it will still create a new dataset on publish.
Reference : Separate reports from models in Power BI Desktop - Power BI | Microsoft Learn
Hope this helps !!If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.
Hi Avih
Yes, what you're experiencing is the expected behavior in Power BI. When you publish a report from Power BI Desktop—even if it connects to another semantic model (dataset) in Desktop—Power BI Service treats the published file as a standalone report and automatically creates a new semantic model associated with it. This happens because Power BI Desktop doesn’t truly support live connections to Power BI Service datasets; it connects to local copies of those datasets during development. When published, these connections don’t carry over as live links but are instead embedded as either static imports or re-published semantic models, resulting in duplication.
To avoid creating duplicate semantic models in the service, the best practice is to develop and maintain your centralized or “main” semantic model separately—publish it once to the Power BI Service—and then, for all dependent reports, do not build them in Desktop by connecting to a local version of that semantic model. Instead, after publishing the main model, create the dependent reports directly in the Power BI Service or in Power BI Desktop by using the “Power BI datasets” connector, which connects live to the published dataset in the service. This way, when you publish those reports, you can choose to publish just the report (without its own dataset), thereby preserving a single source of truth and avoiding dataset duplication. You can do this by publishing a report file created from a live connection (which shows "Live connection" mode in Desktop) to the same workspace as the main dataset or a different one, depending on your governance setup.
- v-aatheeque1 year ago
Community Support
Hi Avih ,
If these solutions related to create separate semantic models when published helped resolve your issue which was posted earlier.
we’d greatly appreciate it if you could mark this as the Accepted Answer it helps others facing a similar challenge find it quickly.
If there’s anything else you’d like to clarify or if you need further assistance, please don’t hesitate to share we’re here to help!
Thanks once again for your valuable contribution to the Microsoft Fabric Community!
- v-aatheeque1 year ago
Community Support
Hi Avih
Have you had a chance to look into this? If you need any further assistance regarding desktop still create separate semantic model this please don’t hesitate to reach out!
We also noticed that we haven’t heard back from you in a while. If the previous response was helpful, we would appreciate it if you could mark it as the Accepted Answer. This will help others in the community who may be facing similar challenges.
Thank you for your engagement!
- v-aatheeque1 year ago
Community Support
Hi Avih
Have you had a chance to review this guidance or proceed with the upgrade? If you're planning the transition and need support, feel free to reach out we’re happy to help!
Also, we noticed there hasn’t been a response in a while. If the earlier reply addressed your concern, please consider marking it as the Accepted Answer to assist others in the community with similar questions.
Thanks again for your participation in the Microsoft Fabric Community!