Forum Discussion

CLede1210's avatar
CLede1210
Regular Visitor
1 year ago

Switch RLS on and off within the same semantic model

Hello,   We have the need to leverage multiple different RLS rules while using the same data. This has cuased us to create very similar datasets with the only difference being how RLS is applied on...
Data Protection
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

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

littlemojopuppy's avatar
littlemojopuppy
Community Champion
1 year ago

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...