Power BI Report based on multiple semantic models

[MarvEw1111]

Hello,
unfortunately I have not yet found a solution how to create a Power BI report based on multiple semantic models.
Is there a solution or a workaround how such a report can be created?

Best regards!

[MarvEw1111]

Hi, 

the connection to one dataset works finde. But we would like to combine more than one semantic model in one Power BI Report. 

[Idrissshatila · Accepted solution]

Hello @MarvEw1111 ,

yes it works with several semantic models, you just need to use the connector more than once for each semantic model.

[MarvEw1111]

I checked my connectors but unfortentaly I do not have this connenctor. I'm using the version June 2024.

[Idrissshatila]

Hello @MarvEw1111 ,

it's under the microsoft fabric

[MarvEw1111]

I found it but it only allows one semantic model connection 

[Idrissshatila]

Hello @MarvEw1111 ,

yes, but you can do it several times, so you first pick the semantic model, then you get another data from the same connector and so on.

I tried it myself and it worked.

[PBILover]

Hi @Idrissshatila 
How you can achieve if you want to combine the data from multiple semantic models , without need to refresh the new one ?

[Idrissshatila]

Hello @MarvEw1111 ,

did you try to connect to the semantic model published in service using the connect to semantic dataset connection in Power bi and it didn't work?

check it out https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets