Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

RLS causes that the users not in RLS group can't access the data

Hi, there,   I created an RLS group by precisely following the instructions https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls. I have an existing report "REPORT A" and it ha...
  • Tutu_in_YYC's avatar
    Tutu_in_YYC
    3 years ago

    USER X and GROUP Y have to be assigned with an RLS Role. If these 2 are allowed to see all data in REPORT A, you still need to create an RLS role without any data filter in it and assign it to USER X and GROUP Y.

    Basically, if a report has RLS, only those with assigned RLS roles can access it.

Tutu_in_YYC's avatar
Tutu_in_YYC
Super User
3 years ago

USER X and GROUP Y have to be assigned with an RLS Role. If these 2 are allowed to see all data in REPORT A, you still need to create an RLS role without any data filter in it and assign it to USER X and GROUP Y.

Basically, if a report has RLS, only those with assigned RLS roles can access it.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks Tutu_in_YYC ! I make it as an accepted solution.

 

It is so sad I can't see this important information on the PowerBI documentation, even the screenshots used in the document all have only one RLS role which may make the people misused it.