Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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.
For classic workspace, you could set "members can only view Power BI content".
For new app workspace, you could assign a viewer role.
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.
For classic workspace, you could set "members can only view Power BI content".
For new app workspace, you could assign a viewer role.
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.
Any overlapping/conflicting rules? Remember that RLS is optimistic - permissive rules override restrictive rules.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.