Forum Discussion

Jerome_C63's avatar
Jerome_C63
Frequent Visitor
3 years ago

How to implement Dynamic Row Level Security

Hello community.

 

I need your support because i don't find a way to achieve my goal... Namely to restrict the view to a drop-down list of my report based on userprincipalname().

 

I have a table named "Access" that contains all my Excel files in the "File" column and then the other columns are named with the UPN of each of my users. In terms of values, I put 1 to authorise the view on my file and 0 if I want to prohibit it. And a user can have access to certain files and others not.

 

File[email protected][email protected][email protected]
File_Deployment.xlsx111
File_Migration.xlsx100
File_Test.xlsx101
File_Template.xlsx100

 

I've already set up a relationship between my "Access" table and my other "Dataset" table based on the file name. I enabled security filter in both directions and relationship is active.

 

Do you know if we can use dynamic row level security? And if so, can you help me?

I don't really know how to set up the DAX query at role level (I've never used this feature before). I've tried several ideas without success.


Can you give me your ideas and suggestions so that I can use this table to filter my view only on files authorised for the user who will connect to the report?

 

I will appreciate your help.

 

Thanks in advance