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 | toto.tata@domain.fr | titi.tutu@domain.fr | tuto.tita@domain.fr |
| File_Deployment.xlsx | 1 | 1 | 1 |
| File_Migration.xlsx | 1 | 0 | 0 |
| File_Test.xlsx | 1 | 0 | 1 |
| File_Template.xlsx | 1 | 0 | 0 |
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
