Forum Discussion
Helper IVUser wants to use two different Semantic Model Data to build report, how to do that
We have two different semantic models, and user wants to use the two semantic model data to build a report. Can we use two diff. model in same report? if Yes, how to do it?
Hi pennyhoho117 ,
Thanks for reaching out in Microsoft Fabric Community.
Thanks Akash_Varuna for your inputs.
To build a report using two different semantic models, you can follow one of the methods below:
Method 1: Composite Models with DirectQuery in Power BI Desktop- Open Power BI Desktop.
- Click on Get Data -> Select Power BI semantic models.
- Choose the first semantic model and click Connect.
- Repeat the process to connect to the second semantic model.
- Power BI will force DirectQuery mode for both datasets.
- Navigate to Model View and create relationships if necessary.
- Build your report using data from both semantic models.
- Publish the report to Power BI Service.
Note:
When combining multiple Power BI semantic models, both use DirectQuery, and Import Mode is not allowed. If you need to mix Import Mode and DirectQuery, you should connect to a database like SQL, Lakehouse, or Warehouse instead of another semantic model.
DirectQuery can impact performance since queries are executed directly against the source models.
Method 2: Using Dataflows in Power BI Service- Identify the original data sources (Lakehouse, SQL Database, Warehouse) for each semantic model.
- In Power BI Service, create a new Dataflow, then click on Get Data and select the appropriate Lakehouse, Warehouse, or Database where the semantic model is associated.
- Choose the authentication method and click Connect.
- Repeat the process for the second semantic model.
-
Combine Data – Use the Combine option in the top ribbon to:
- Append Queries (to stack data from both sources).
- Merge Queries (to join data based on a common key).
- Add a data destination (Lakehouse, Warehouse, SQL Database, or Kusto Database) and publish the Dataflow.
- Go to the SQL endpoint of the destination database to build the report, or use Power BI Desktop to connect to the published Dataflow, build the report, and publish it to Power BI Service.
Hope this helps. Please reach out for further assistance.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and a kudos would be appreciated.
Best Regards,
Vinay.
6 Replies
- Akash_Varuna
Super User
Hi pennyhoho117 , Yes, you can use two semantic models Please try these out
- Composite Models: Use DirectQuery to connect both models and relate their data.
- Dataflows: Consolidate data from both models into a single dataset via dataflows or ETL tools like ADF.
- Hybrid Approach: Combine DirectQuery for one model and Import mode for the other.
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance
pennyhoho117Can you tell me detail procedure in creating Dataflow for two semantic model?
v-veshwara-msftCommunity Support
Hi pennyhoho117 ,
Thanks for reaching out in Microsoft Fabric Community.
Thanks Akash_Varuna for your inputs.
To build a report using two different semantic models, you can follow one of the methods below:
Method 1: Composite Models with DirectQuery in Power BI Desktop- Open Power BI Desktop.
- Click on Get Data -> Select Power BI semantic models.
- Choose the first semantic model and click Connect.
- Repeat the process to connect to the second semantic model.
- Power BI will force DirectQuery mode for both datasets.
- Navigate to Model View and create relationships if necessary.
- Build your report using data from both semantic models.
- Publish the report to Power BI Service.
Note:
When combining multiple Power BI semantic models, both use DirectQuery, and Import Mode is not allowed. If you need to mix Import Mode and DirectQuery, you should connect to a database like SQL, Lakehouse, or Warehouse instead of another semantic model.
DirectQuery can impact performance since queries are executed directly against the source models.
Method 2: Using Dataflows in Power BI Service- Identify the original data sources (Lakehouse, SQL Database, Warehouse) for each semantic model.
- In Power BI Service, create a new Dataflow, then click on Get Data and select the appropriate Lakehouse, Warehouse, or Database where the semantic model is associated.
- Choose the authentication method and click Connect.
- Repeat the process for the second semantic model.
-
Combine Data – Use the Combine option in the top ribbon to:
- Append Queries (to stack data from both sources).
- Merge Queries (to join data based on a common key).
- Add a data destination (Lakehouse, Warehouse, SQL Database, or Kusto Database) and publish the Dataflow.
- Go to the SQL endpoint of the destination database to build the report, or use Power BI Desktop to connect to the published Dataflow, build the report, and publish it to Power BI Service.
Hope this helps. Please reach out for further assistance.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and a kudos would be appreciated.
Best Regards,
Vinay.- v-veshwara-msft
Hi pennyhoho117 ,
Just following up on your issue. If the provided response has resolved your concern, please mark it as the Accepted Solution to help others with similar queries. If you need further assistance, feel free to reach out.
Thank you!
- v-veshwara-msft
Hi pennyhoho117 ,
We haven’t heard from you since our last response and wanted to check if the provided solutions met your needs. If they did, please consider accepting the solution to help others benefit. Otherwise, feel free to reach out for further assistance.
Thank you!
- v-veshwara-msft
Hi pennyhoho117 ,
May I ask if the solution provided has addressed your needs? If so, please consider marking it as Accepted Solution to help others with similar queries.
If you need any further assistance, feel free to reach out.
Thank you.
