Forum Discussion
rls multiples values
Hi twister8889
To my knowledge, as you are using the dynamic RLS, in your user table you will need to repeat the user for a lot of rows to each key. Or I will call it a Role table which is used to define data access level for every user. And actually it will form a many-to-many relationship between users and keys. Please refer to below link for more guide about this:
https://radacad.com/what-do-you-need-to-implement-dynamic-row-level-security-in-power-bi
https://radacad.com/dynamic-row-level-security-with-profiles-and-users-in-power-bi
Kindly let me know if this helps.
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
First of all, thank you for your answer..
I found this post, what do you think about this:
https://xxlbi.com/blog/configuring-all-access-with-dynamic-row-level-security/
twister8889 Thanks for sharing this link. It's a great blog. I think I need to dig deeper into RLS and DAX.