How to implement Dynamic Row Level Security

[Jerome_C63]

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

[miTutorials]

Please take a look at this tutorial - hope this helps.

Create Row Level Security (RLS) to restrict access in PowerBI | MiTutorials - YouTube

[Idrissshatila]

Hello @Jerome_C63 ,

refer to this https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin