How to Bypass RLS Filters for Certain group of users

[kishore23348]

I have RLS Implementation in RLS by joining with Security Model to Fact Data set and Created Useremailid=UserprincipalName() function for RLS in Manage Roles .

But i have few set of users where they can see all the data in the fact model by overrdiding RLS condition , with giving Memeber roles as Contributor /Owner in Service .

[Sahir_Maharaj · Accepted solution]

Hello @kishore23348,

You can utilize the Contributor or Owner roles in Power BI service:

1. Create a new role in your Security Model specifically for the users who need to bypass RLS. Let's call it "Bypass RLS."

2. Assign the "Bypass RLS" role to the users who should have unrestricted access to the fact model.

3. In the Power BI service, navigate to the dataset for the fact model. Go to the "Security" and click on "Add Group or User."

4. Add the users who need to bypass RLS to the Contributor or Owner roles.

Should you require further details or assistance please do not hesitate to reach out to me.