Forum Discussion
Switch RLS on and off within the same semantic model
Hi CLede1210 ,
RLS only restricts data access for users with Viewer permissions(RLS is ON). It does not apply if your workspace role is Admin, Member, or Contributor(RLS is "OFF" ).
Based on your description, it appears you aim to display different data by applying various RLS rules on the same semantic model. We can create multiple reports base on one same semantic model. You can refer to the links below for guidance on setting up static or dynamic RLS for your reports.
Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn
Dynamic Row Level Security with Power BI Made Simple
Best Regards
Hi Anonymous we looked at dynamic RLS for some of the reports (those visible to specific sales people and their managers). But we have other reports with intended audiences of product line managers or things like that. Because of the conflicting RLS rules, it's not possible to combine all the rules in the same model. End result, like CLede1210 said, is virutally identical models for different audiences. And these are very large datasets, so it's obviously not practical to do this either.
ajohnso2 we thought about different pages of reports in apps but the maintenance involved with exposing pages to the correct user(s) when people change jobs frequently is also not a practical approach.
I'm pretty sure that what we want to do isn't possible because RLS and OLS are defined as part of a model (and not in reports based on a model). But was hoping someone had a trick on how to accomplish the objective...
