Row level security on power bi reporting server

[joannasokolowsk]

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

[d_gosbell · Accepted solution]

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)

[joannasokolowsk]

Perfect! thank you for the help!

Asia