Forum Discussion

joannasokolowsk's avatar
joannasokolowsk
Icon for Helper II rankHelper 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) ,...
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)

d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper 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)