Row Level Security issue in Service

Hi Anonymous 

It's great to hear that you've identified the role of the user (Admin vs. Viewer) impacts the application of RLS, as RLS filters are indeed not applied to users with Admin, Member, or Contributor roles within a workspace. Changing the first user's role to Viewer in the DEV environment and observing the expected behavior was the correct approach.

Double-check that the first user's role is indeed set to Viewer in the UAT environment. It's possible the role change did not apply or save correctly.

Ensure that the RLS configuration (roles and DAX expressions) in the UAT environment exactly matches that of the DEV environment. Any slight difference in DAX expressions or role assignments can lead to different behaviors.

Sometimes, cached credentials or data in the Power BI Service can cause unexpected behavior. Ask the first user to clear their browser cache or try accessing the report in an incognito/private browsing window to see if the issue persists.

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.