Search code examples
powerbipowerbi-desktop

What does it mean by Power BI report references a row with RLS?


Keep in mind that if a Power BI report references a row with RLS configured then the same message displays as for a deleted or non-existing field. To these users, it looks like the report is broken.

https://learn.microsoft.com/en-us/fabric/security/service-admin-row-level-security#considerations-and-limitations

I'm looking for an example to understand what this means.


Solution

  • Row Level Security (RLS) gets checked on report load. If a rule on a table can't be checked because the filtered field no longer exists, all visuals referencing that table will break.

    So for example, imagine you have users John and Tim, and a table Users that contains the field email.
    Then you add a filter role on table Users for user Tim that filters out the email field.

    • If you delete the Users table, nothing will happen, since the RLS filter will get deleted with it. Both users will be able to see the same unfiltered data.
    • If you delete the email field, Tim won't be able to see any visual that references the Users table. Displaying the same error it would if a field on that visual no longer existed, but with a different error message once you click on See details:

    enter image description here

    enter image description here

    While editing the Dataset, an error will appear informing the user that one or more RLS filters have errors:

    enter image description here