Forum Discussion
Power BI – Dynamic Row Level Security
I have a requirement to provide access to several users based on multiple columns of a table., on which I am currently facing issue. Let me explain it in a much detail manner For example, My Hier...
You should be able to allocate a person to multiple categories.
I'd set up security views that allow access to each descreet aspect, then assign a person to each category.
For example, if you only wanted someone to have access to "Apples" and "Bananas", but also access to the category "Candy". I'd create a group that has access to the apples and bananas, then a seperate group for candy. You can then add the person to both groups, giving them access to only those 2 sets.