Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.