Forum Discussion
Using measures from multiple semantic models
Hi,
I have a question about using multiple semantic models in same file.
Let's say that I have a "master" model that has calendar table and own measures etc. I have also own semantic models for invoice data, sales data and stock data. Each model have own calendar table and measures and those models can be used independently. Each model have dozens of measures and all models are published in the Service.
How to use measures from different models in the same visualization in master model file? Can I make relationship from master model calendar table to each calendar table of those imported models? If not, what is the solution for this situation?
Hii Testeri
Measures from different models cannot interact in the same visual unless they are in a single composite model. The supported solution is to create a new Power BI report using DirectQuery for Power BI datasets (composite model) and connect to all required semantic models. This creates a local model where you can define relationships (e.g., one master calendar table) and use measures from multiple models in the same visual. Without using a composite model, it is not supported.
4 Replies
Hii Testeri
Measures from different models cannot interact in the same visual unless they are in a single composite model. The supported solution is to create a new Power BI report using DirectQuery for Power BI datasets (composite model) and connect to all required semantic models. This creates a local model where you can define relationships (e.g., one master calendar table) and use measures from multiple models in the same visual. Without using a composite model, it is not supported.
You can use measures from different semantic models in a direct query mode in the same visual if you use a table that bridges the two. You can still use one of the dates table to relate to the other semantic model granting that that table includes all the dates between the two.
Hi Testeri,
Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.
Thank you.
