Using Two PowerBI Semantic Models in same PBIX File

[DPCCGF]

I have to create a PBIX data from two different PowerBI Semantic models.  How can I use the Get Data method to connect to two different Power BI Semantic models in ONE PBIX file.  Potentially down the road adding in another one?  Thanks in advance!

[johnt75 · Accepted solution]

You can use composite models, https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models , but I would not recommend it if you have any other choices. In my experience running reports from composite models is really slow. If there is any way to combine the data into a single semantic model then it will be much faster.

[Anonymous · Accepted solution]

Hi @DPCCGF ,

You need to publish the two pbix files to the workspace and connect then integrate the data through the power bi semantic model connector.

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[johnt75 · Accepted solution]

You can use composite models, https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models , but I would not recommend it if you have any other choices. In my experience running reports from composite models is really slow. If there is any way to combine the data into a single semantic model then it will be much faster.