Forum Discussion

joannasokolowsk's avatar
joannasokolowsk
Helper II
5 years ago
Solved

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

Row Level Security
Server
  • d_gosbell's avatar
    d_gosbell
    5 years ago

    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)

2 Replies

  • d_gosbell's avatar
    d_gosbell
    Super User
    5 years ago

    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)