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.

    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