Forum Discussion

NielsBakker's avatar
NielsBakker
Frequent Visitor
1 year ago
Solved

Dynamic RLS - DAX help needed

Hi!    In PowerBI, we have a data model and want to apply a quite flexible data security that includes all possible scenario's. To achieve this we are thinking about using a UserSecurity table, whi...
"DAX " "DAX help" 'Need help'
Dynamic RLS
  • v-venuppu's avatar
    v-venuppu
    1 year ago

    Hi NielsBakker ,

    Thank you for reaching out to Microsoft Fabric Community.

    Thank you Greg_Deckler for the prompt response.

    I tested it with "View as" and it worked as expected. The RLS filtered the RESOURCEUSAGECOST table correctly based on the UserSecurity table.
    I manually dragged fields into the table visual, and only the allowed SUBSCRIPTIONIDs for the test user were shown.

     

    Please find the attached PBIX file for your reference.

    Thank you.

NielsBakker's avatar
NielsBakker
Frequent Visitor
1 year ago

Greg_Deckler thank you very much for the quick response. Unfortunately, I get the following error message when applying the RLS. I've used your DAX on the Fact table that needs to get filtered in Manage Roles.

 

 

Not sure what needs to be changed to make it working. 

 

Let me know if more information is needed!

Many thanks!

 

Niels