Forum Discussion
One Semantic Model for Multiple Reports
Hi ndias ,
Thank you GeraldGEmerick , for your insights,RLS is most effective when all customers use a shared semantic model or report within a single workspace, allowing data to be filtered for each user. Because your customers each have their own workspace and app, you’re using a workspace-per-tenant isolation model. In this setup, a single master model can’t adjust parameters for each workspace from the report side, so some duplication is unavoidable. The recommended approach is to maintain one master PBIX file and automate its deployment to each workspace, setting the parameter for each customer as needed.
Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn
Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn
Develop scalable multitenancy applications with Power BI embedding - Power BI | Microsoft Learn
Thank you.
hi GeraldGEmerick , thanks for answering! I believe that will work for a dashboard published in one Fabric/Power BI workspace to which all viewers have access. In my case each customer has its own workspace and App (and thus I have several security groups). Or am I missing something here?
Hi ndias ,
Thank you GeraldGEmerick , for your insights,RLS is most effective when all customers use a shared semantic model or report within a single workspace, allowing data to be filtered for each user. Because your customers each have their own workspace and app, you’re using a workspace-per-tenant isolation model. In this setup, a single master model can’t adjust parameters for each workspace from the report side, so some duplication is unavoidable. The recommended approach is to maintain one master PBIX file and automate its deployment to each workspace, setting the parameter for each customer as needed.
Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn
Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn
Develop scalable multitenancy applications with Power BI embedding - Power BI | Microsoft Learn
Thank you.