Forum Discussion
Dynamic RLS with USERPRINCIPALNAME() works in Service “View as role”, but real users can’t access un
Hi YogeshWaran2010,
1: yes, once RLS is enabled, only members with a role will be able to view data.
2: use AD groups
3: It is by design that users with workspace level roles contributor and higher bypass RLS.
Workspace members assigned Admin, Member, or Contributor have edit permission for the semantic model and, therefore, RLS doesn’t apply to them.
Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution
Hi YogeshWaran2010,
1: yes, once RLS is enabled, only members with a role will be able to view data.
2: use AD groups
3: It is by design that users with workspace level roles contributor and higher bypass RLS.
Workspace members assigned Admin, Member, or Contributor have edit permission for the semantic model and, therefore, RLS doesn’t apply to them.
Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution
Thank you for your prompt response. It would be helpful if you could provide guidance on setting up the Active Directory groups in Azure, including documentation or implementation videos. Thank you.
