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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
joannasokolowsk
Helper II
Helper II

Row level security on power bi reporting server

Hi guys,

I want to ask about your advice regarding using row level secutiy option. I have many users (around 4000)  that should see only their own information (and I used row level security level) , but also a big group of people (around 2000)  that should see everything. Is is possible to have it on one dahsboard? If, yes how this should be applied? 

 

Thanks,

Asia

1 ACCEPTED SOLUTION
d_gosbell
Super User
Super User

You would create 2 roles, one with the RLS rule and one with no restrictions. Then you just add the relevant people/groups to the relevant role (making sure that a given user is only in one of the two roles)

View solution in original post

2 REPLIES 2
d_gosbell
Super User
Super User

You would create 2 roles, one with the RLS rule and one with no restrictions. Then you just add the relevant people/groups to the relevant role (making sure that a given user is only in one of the two roles)

Perfect! thank you for the help!

 

Asia

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.