Forum Discussion

AnthonyJoseph's avatar
AnthonyJoseph
Resolver III
2 years ago

Bypass RLS through DAX in Manage roles section

Hello Community,   In our dashboard are currently using RLS (user email = userprincipalname()) to show data based on the logged in user. Now, we need to bypass this RLS when the user is from "Admin...
"DAX"
Manage role
MargusMartsepp's avatar
MargusMartsepp
New Member
2 years ago

You can use an OR condition in the DAX formula to check if the user is part of the "Admin" team. If they are, the RLS filter will not be applied.

= 
(
    [user email] = USERPRINCIPALNAME() 
    || 
    LOOKUPVALUE('Admin_RolesAndPermissions'[Team], 'Admin_RolesAndPermissions'[user email], USERPRINCIPALNAME()) = "Admin"
)

Just as a reminder to implement this, you would:

  1. Go to the "Modeling" tab in Power BI Desktop.
  2. Click on "Manage roles."
  3. Create a new role or edit an existing one.
  4. Paste the DAX filter expression next to the table where you want to apply RLS.
  5. Save and close the "Manage roles" window.
  6. Before publishing, you can view the report as roles to test the RLS.