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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

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!

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

     

    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."