Forum Discussion
RLS - Role Security based on multiple values
Hi,
We are trying to make roles based on different options:
Business is running in several countries and have 3 different business lines (A, B, C). Users, based on their role should be able to see n countries and n business units or all.
Example:
| User | Country | Business Unit |
| A | ES | A |
| A | FR | B |
| B | IT | ALL |
| C | ES | B |
| C | FR | A |
| D | ALL | A |
We would like to have a dynamic filter based on the user connected (USERPRINCIPALNAME()) but at the moment we struggle to have the expression correctly to be able to select more than one value.
Could you please help us getting the right expression so if user A connects is able to see countries ES, FR and Business units A and B??
Thanks and kind regards,
3 Replies
Hi Anonymous,
Based on my research, you need to create a table with user email address and create relationship with your data table, then use the USERNAME() function to filter the RLS data in your Power BI Desktop, you could refer to below blog:
http://radacad.com/dynamic-row-level-security-with-power-bi-made-simple
Regards,
Daniel He
Hi v-danhe-msft, thanks for your answer.
The problem I see here is that you would need another table with unique values to be able to relate it with the masterdata.
My ideal solution would be to be able to do a dynamic call to the security table where I could get the related restrictions.
Let me know if I need to give further clarification :)
Thanks!
