RLS userprinciplename not working for a user

[Anonymous]

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 · Accepted solution]

Hi @Anonymous 

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

[Anonymous]

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 🙂

[GilbertQ]

Thanks for letting us know!