Row level security not working

[Anonymous]

Hello,

I have implemented row level security using userprincipalname() dax. After I publish and configure the security it works fine, filters rows accordingly. But after say 10 mins, if I try to test as role for the same person it shows me the entire data. 

Any leads or help on why this is happening or what am I doing wrong !!

Thanks! 

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

If you have configured the workspace so that members have edit permissions, the RLS roles will not be applied to them. Users will be able to see all of the data.

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls#using-rls-with-workspaces-in-power-bi

For classic workspace, you could set "members can only view Power BI content".

For new app workspace, you could assign a viewer role.

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-new-workspaces#roles-in-the-new-workspaces

[v-xuding-msft]

Hi @Anonymous ,

Have you resolved it? Can you please accept the answers that you make sense as solution? Others who have the same issue will benefit from this thread.

[lbendlin]

Any overlapping/conflicting rules?  Remember that RLS is optimistic - permissive rules override restrictive rules.