Solved: RLS userprinciplename not working for a user

Anonymous · ‎04-19-2022

Hi,

I have a report with RLS userprinciplename and for 1 user it shows all the data instead only his departmentsdata. RLS for other users looks ok and they only see their data in the report.
Is there a hidden all data access, ie RLS will not work, for this particular user (email) to the workspace that is not visible in the service?

GilbertQ · ‎04-19-2022

Hi @Anonymous

Can you confirm that the user is not a member, contributor or Admin of the App Workspace?

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Power BI Blog

View solution in original post

GilbertQ · ‎04-19-2022

Hi @Anonymous

Can you confirm that the user is not a member, contributor or Admin of the App Workspace?

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Power BI Blog

Anonymous · ‎04-25-2022

Hi,

Tnx for reply.

The user is a member of the workspace, so RLS will not work for this role/user. Immediately after change/remove the role for the user, RLS was still not working. Apparently It took same time later that the RLS works for the user 🙂