Insights / RLS in Power BI / Part 13
Part 13 of 20 · Share itUser in two RLS roles? How Power BI combines them
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:
- One role, two filters → both must match (AND)
- Two roles → either one is enough (OR)
- 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. - A role with no rules shows every row.
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.