RLS does not work in my report（but works in the "views as role"）

[MAYUKO]

I have implemented row level security in powerbi desktop and it works fine when i test it in the "view as role" function but when I publish it to the PBI service and read the report, it does not work anymore.

The details are as follows,

・I created "superviser"role and tried to filter the data by "sectioncode" of each user

　formula; [sectioncode] = LOOKUPVALUE([sectioncode], [mailaddress], USERPRINCIPALNAME())

・It works when i tested in the "view as role"（both PBI desktop and service）

・Already add the members to each role

Please give me the solution.

Thanks so much for your help!

[Anonymous · Accepted solution]

Hi @MAYUKO 

There is nothing wrong with your procedure . But RLS only restricts data access for users with Viewer permissions. It doesn't apply to Admins, Members, or Contributors. So, you have to make sure that the users you add are viewer roles and nothing else. 

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MAYUKO]

Thank you so much for the reply! I’ll check the users roles!!