Forum Discussion
Power BI – Dynamic Row Level Security
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.
I already have a similar setup being used for controlling access.
I have separate tables for the three columns (say Product Category, Subcategory and Product Name) and the User Name being added to those tables for controlling the RLS. This is then joined with the data set.
Over a period of time as new items get added based on which further access control is required, this approach might become difficult for maintenance
