Forum Discussion
Using measures from multiple semantic models
- 6 months ago
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.
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.