Forum Discussion
Dashboard with multiple RLS roles work in My Workspace but fails in Premium workspace
Hi Anonymous ,
This issue has been submitted internally.
Internal ICM ID: 280683445.
If there is any news, I will update it here.
Best Regards,
Jay
Community ChampionDon't think it's a fix as such but have a read through this thread
As far as we could tell in the December release of power bi desktop and service many to many cardinality relationships stopped working when multiple roles were selected.
Suspect if you upgrade power bi desktop you'll get the same error. The slightly odd bit is reading your post sounds like it is still working ok in My Workspace?
- bcdobbs
Looking at your relationships and demo data...
"
Relationship:
User (1) --[cross filter: single]--> (*) User Profile (*) --[cross filter: single (user profile filters profile)]--> (*) Profile"
why is User Profile to Profile, Many to Many?That's the only way to get it working when user is assigned to 2 roles with both static and dynamic RLS roles.
Well the dashboard was working with the multiple RLS roles about 3 weeks ago and stopped working in Jan 2022. So, I did suspect some sort of update might be the cause but my version of the PI Desktop is the Sept 2021 version.
I also understand the odd part about the dashboard working on one workspace and not on another workspace. I tried changing the file name to test just in case it wasn't a caching issue but same results. I really do not get why it stopped working in Premium workspace. Not sure if the powerbi service workspaces are different - Premium vs personal workspace.
- bcdobbs
Out at the moment but I'll try uploading my test file to my workspace do see if we get the same result.
All a bit odd!
A bit more information. I do get similar error as the thread you shared regarding security filters = both. However, I do not have security filter enabled for any of the relationships for all my tables. I may have some relationships with cross filter = both but not security filter enabled for any of them.
Error msg: "The user belongs to multiple roles 'profile1, profile2' that have security filters, which isn't supported when one of the roles has filters affecting table 'records' with SecurityFilteringBehavior=Both relationships."