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 ...
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!
Anonymous, did you find any relevant solution?
Regards