Forum Discussion
Dashboard with multiple RLS roles work in My Workspace but fails in Premium workspace
I have set up a dashboard with dataset for users similar to this blog: https://radacad.com/dynamic-row-level-security-with-profiles-and-users-in-power-bi
User table
| user_name | user_email |
| user1 | [email protected] |
| user2 | [email protected] |
| user3 | [email protected] |
User Profile table
| user_email | profile_name |
| [email protected] | profile1 |
| [email protected] | profile2 |
| [email protected] | profile2 |
| [email protected] | profile3 |
Profile table
| profile_name | profile_status |
| profile1 | prod |
| profile2 | prod |
| profile3 | prod |
Relationship:
User (1) --[cross filter: single]--> (*) User Profile (*) --[cross filter: single (user profile filters profile)]--> (*) Profile
I have also set up a bunch of static RLS roles for security groups with the same name for the profiles. One user can belong to multiple RLS roles
DAX expression are set up in the following tables
User table - Dynamic RLS: [user_email] = USERNAME()
User Profile table - Static RLS: [user_email] = USERNAME() || [profile_name] = "profile1"
The dashboard when tested for multiple roles including both static and dynamic RLS roles, works fine in PowerBI Desktop and also My Workspace after published. Somehow, the dashboard stopped working after published to a Premium workspace. Has anyone experience this before?
Would greatly appreciate if anyone knows how to fix this or could give some pointers on how to fix this.
15 Replies
Any news on updates? It's causing large issues for our organization now. Thanks!
Any further updates on this? I am also experiencing this issue
Hi,
I would also like to report that this is happening in my organisation. Only when people are in multiple roles.
Any update on this?
Thanks,
Chris
Don'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?
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?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.
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!
