Forum Discussion
Semantic Model - adding additional sources / Unconnecting from one
Hi TMUser ,
Using composite models with Power BI semantic models and Analysis Services, you can build a composite model using a DirectQuery connection to connect to Power BI semantic models, Azure Analysis Services (AAS), and SQL Server 2022 Analysis Services. Using a composite model, you can combine the data in these sources with other DirectQuery and imported data.
More details: Use composite models in Power BI Desktop - Power BI | Microsoft Learn
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details.
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi TMUser
When you are using Data source is Semantic Model, it is works like live connection and you are not able to add more data source. Any thing you need to add, please add in Semantic Model and then you can use this for your report.
Hope this helps
Let me know if that works for you
If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.
Thanks
Pijush
Linkedin
Hello PijushRoy,
thank you for your reply. I was wondering about the idea, where a report can connect to more than one model, as suggested in this post: https://community.fabric.microsoft.com/t5/Desktop/Semantic-Model-Advice/m-p/3721457#M1211309. (which I should have included in my first post)
This would have solved a basic requirement: providing some common tables/datasets as basis for different semantic models.
So basically, if the scope, grain or detail in one semantic modell is not enought, one is required to enhance that model. Sharing already modeled data with different models is not possible