Forum Discussion
Row Level Security with different groups
Hello! I am looking to create row level security for two different sets of people. I have been told that managing permissions on the service itself is not the way the group wants to manage this, ...
Anonymous
If you create another role in PowerBi Desktop, one that does not have any filters, then you can add users to that role and they will be able to see all the data.
In order for RLS to work however, you must assign users to the role in the service. The best way to handle that is with Active Directory security groups. You assign the users to the security group and the security group to the role. That way, if you need to add new users to a role they can just be added to the security group.
Hey, I would go directly for dynamic RLS, using security tables, because it's the most scalable option, and scale is inevitable.