Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

RLS and OLS in same power bi report

Hi all,

I am new to this community and will appreciate your help regarding my issue.

I have a power bi report with different geographical regions. I have set up an RLS for different users getting access to different regions.
But there is 1 page with sensitive info that I want to restrict for some of these users. The visuals on this page are coming from a separtae table.
I have created 2 roles :
1. RLS : Dynamic rls set up on this role based on regions. they CAN see sensitive page.

2. RLS and OLS: Dynamic rls set up on this role based on regions. they CANNOT see sensitive page.
In Tabular editor, I restricted Object level security of role "RLS and OLS" to NONE for the sensitive table.

Now, role RLS is working fine.
in role RLS and OLS, users see broken visuals on Sensitive page, but the rls (dynamic rls based on region) for them is not working on other pages. Means they can see everything on other pages.

I want a solution so that they can not see sensitive page, but dynamic rls work for them on other pages.

Please suggest!!


Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors