Forum Discussion
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. How can I use these pre-existing semantic models to accomplish this?
Thanks
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
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.
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
