CODEWITHSUNDEEP
powerbipowerbi-desktoprow-level-security
Marl
Marl

Reputation: 103

Row Level Security (RLS) in Power BI with multiple roles does not work anymore - no change made actually

I have a Power BI report that I publish as an app to several people. Let's assume, the report has a table "Reps" and a table "Customers".

The "rep table" has the following interesting columns:

The "Customer table" has the following interesting columns:

The "Rep Nr" is the join key, while it is a many to many (m:n) relationship, where the direction is "rep" filters "customer". With RLS, I created different roles. For example:

The setting is, that I advise a complete (email/user) distribution list to the role Rep by default. In this role, everyone is included, and each rep sees only his customers. In the role region 1 are some people included, that can see not only his customers, but all customers of this region.

This worked perfectly fine for more than a year. It was never a problem to assign a user to several roles. However, since approximately mid of Cecember 2021, it does not work anymore. I did not change anything. People who are assigned to n roles, cannot see any data.

The message I get in Power BI Desktop:

Couldn't load the data for this visual. The user belongs to multiple roles 'Region 1, Rep' that have security filters, which isn't supported when one of the roles has filters affecting table 'Customers' with SecurityFilteringBehavior=Both relationships.

Does anyone know if Microsoft/Power BI changed anything that explaines this behavior? Does anyone know if I can easily change it to the old setting?

Upvotes: 0

Views: 4180

Answers (1)

MarcusC
MarcusC

Reputation: 16

There was a change that broke this around the December 2021 update.

Source (See response from v-jayw-msf): https://community.powerbi.com/t5/Service/Dashboard-with-multiple-RLS-roles-work-in-My-Workspace-but-fails/m-p/2264783#U2264783

This was not resolved as of 2/7/2022, but two workarounds have been provided in the Microsoft documentation.

Source: https://learn.microsoft.com/en-us/power-bi/admin/service-admin-rls#issue-multiple-roles-and-limited-relationships

Upvotes: 0

Related Questions