Forum Discussion
Row Level Security with different groups
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.
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.
Thank you for your reply, this is what I'm looking for!. So I would just have a "corporate" role assigned to whatever their security group is and then everyone within that group would be able to see everything, is that right?
I just want to make sure both of my bases are covered:
The dynamic RLS I'm using for managers would still work as well, correct?