Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

bcdobbs's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
4 years ago

Don't think it's a fix as such but have a read through this thread 

https://community.powerbi.com/t5/Desktop/Users-with-multiple-security-roles-suddenly-can-t-see-data/m-p/2253832#M819838

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's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
4 years ago

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? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    That's the only way to get it working when user is assigned to 2 roles with both static and dynamic RLS roles.