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

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.