Forum Discussion

PBILover's avatar
PBILover
Helper V
2 years ago
Solved

Multiple Power BI Semantic model based report

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...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    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 | Microsoft Power BI

     

    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_'s avatar
vicky_
Super User
2 years ago

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.