Amerivike
4 years agoAdvocate II
Status:
Done
December Update Issue - Multiple Roles in Row Level Security causing errors for user
We have had our row level security configured like this for a long time. After the December update, suddenly users that are part of two different security roles are getting an error on all visuals st...
DavidAnton
4 years agoRegular Visitor
jcs93 I will submit a ticket as you suggested.
I have found two other topics about the same issue, so a lot of users are struggling with the same problem:
https://community.powerbi.com/t5/Desktop/Users-with-multiple-security-roles-suddenly-can-t-see-data/m-p/2282557#M827826
https://community.powerbi.com/t5/Service/Dashboard-with-multiple-RLS-roles-work-in-My-Workspace-but-fails/m-p/2264783#U2264783
In the first thread there was a proposed solution (24th message) to change the many-to-many relationships by implementing a bridge table, but unfortunately that does not work. I have tested it and the error message is gone, but so are the restrictions, since it essentially deactivates the security filter.