Multiple Power BI Semantic model based report

[PBILover]

Hi,

In a Power BI service, I have several semantic models that are individually developed for each region. My goal is to produce a report that compiles data from every region into a single report. How can I use these pre-existing semantic models to accomplish this?

Thanks

[PBILover]

Thanks @vicky_  the second solution will not work for me , as these are already established datasets , and have high volumes. 

[Anonymous · Accepted solution]

Hi @PBILover ,

As far as I know, if you only want to create a report based on different semantic models, you can try to connect to Power BI Semantic Models in Power BI Desktop.

However, due to the limitation, defining RLS on tables from a remote source isn't supported. 

For reference: Use composite models in Power BI Desktop - Power BI | Microsoft Learn

Here I suggest you to try to create different reports based on different semantic models and this will keep your report clean.

Then you can publish these report to an app workspace and then publish an app in this workspace.

Currently, we can set multiple audiance for an app. With multiple audiences for an App Power BI App author can create multiple audience groups within the same App and assign different permissions to each group.

For reference: Power BI Org Apps with Multiple Audiences now Generally Available | Microsoft Power BI Blog | Micros...

Best Regards,
Rico Zhou

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

[vicky_]

You can create a new report, but use all the data models from your various regions: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets

An alternative way would be to create a report with ALL the regions as a default, and then use RLS or OLS to control which regions are shown to your end users: https://learn.microsoft.com/en-us/fabric/security/service-admin-row-level-security and https://learn.microsoft.com/en-us/fabric/security/service-admin-object-level-security?tabs=table respectively.