Insights / RLS in Power BI / Part 14

Part 14 of 20 · Share it

RLS and OLS in different roles: fix the error

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

The problem. A user is in an RLS role and an OLS role at the same time. Their visuals show errors.

Why. Roles add up (Part 13). Together, the two roles would show every row plus the hidden column. Power BI blocks that combination, and the error appears when the visual runs its query.

East team (RLS)East rows, Salary shownHide salary (OLS)All rows, no Salary+Together they'd showevery row + Salary→ Power BI blocks it: errorsfixEast managers[Region] = "East"Salary = None (OLS)One role per audience, with both rules
Role What it does
East team (RLS) East rows only, Salary visible
Hide salary (OLS) All rows, no Salary
Both together Would be all rows + Salary → blocked

The fix. Create one role for these users with both rules in it:

  • RLS: the row filter, for example [Region] = "East"
  • OLS: in Tabular Editor, Roles → your role → Table Permissions → set the Salary column to None. (TMDL view in Power BI Desktop works too.)
role 'East managers'
    modelPermission: read
    tablePermission Sales = [Region] = "East"
    tablePermission Employees
        columnPermission Salary = none

Then move the users into this role and take them out of the other two. If they stay in the old roles, the error comes back.

Check before go-live

  • No one is in an RLS-only role and an OLS-only role at the same time Desktop
  • Each audience's row filter and hidden columns are in the same role Desktop

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