Insights / RLS in Power BI / Part 13

Part 13 of 20 · Share it

User in two RLS roles? How Power BI combines them

By Zohal Zahir · November 2026 · From the series Who sees what: RLS in Power BI

The problem. Someone is in two RLS roles. You expect them to see less. They see more.

Why. Power BI adds roles together. A row shows if any of the person's roles allows it.

Example:

  • Role 1: [Product] = "Bikes"
  • Role 2: [Region] = "East"

Someone in both sees all of East, plus Bikes in every region.

The rules:

  1. One role, two filters → both must match (AND)
  2. Two roles → either one is enough (OR)
  3. A "no" in one role can't cancel a "yes" in another. A role with FALSE() on a table doesn't stop another role from showing it.
  4. A role with no rules shows every row.
Role ARegion = EastBikeHelmAppaPartNorthEastSouthWestRole BProduct = BikesBikeHelmAppaPartNorthEastSouthWestIn both roles7 of 16: more, not lessBikeHelmAppaPartNorthEastSouthWestInstead: one roleboth filters → East Bikes onlyBikeHelmAppaPartNorthEastSouthWest+=Two roles = OR. Two filters in one role = AND. A FALSE() in one role can't cancel another.

The fix. Want East Bikes only? Put both filters in one role. Give each person one role that covers everything they need. People often get roles through security groups, so check group membership too.

Test the real combination: View as → tick every role the person holds.

Check before go-live

  • Each audience has one role with all its filters Desktop
  • Group memberships were checked for people in more than one role Service
  • View as was run with all of a person's roles ticked together

Want a second pair of eyes on your own model? The RLS review checks your roles, relationships and workspace access against this checklist, at a fixed price.

Found this useful? Share it.Tag Zohal Zahir on LinkedIn so she can say thanks.

Want your RLS checked on a real model?

Book a free 30-minute call. Tell us how your model and workspaces are set up, and we'll tell you where access could leak and what fixing it would involve.

Book a free call30 minutes. Reply within two business days