Implement RLS for multiple reports

Hi Dimitris_Kats ,

Please check dynamic row level security for this. You need not create multiple roles.

First you need to create user configiration table which will have user name email address and which country they will have access to.

Then go to PBIX->Modelling->Create New Role - > DAX Editor

Here you can give DAX Filter data expression based on the fact table with country column. This DAX expression checks the userprincipal name of logged in user and check the country he has access to.

As a best practice, we just need to maintain this user access table with country and other dimensions/categorigal data he/she should be having access to.

Everytime a new user is added, this user will be added in the table, dataset needs to be refreshed and in the service, the user needs to be added in the security.

If this post helps, please accept this as a solution. Appreciate your kudos.

Thanks,

Pallavi