Forum Discussion
Manage Roles - set row security level help
You can create a dynamic RLS with the function USERNAME() or USERPRINCIPALNAME(), that function will return the power bi user email, so you will have to create a table with all users email like [email protected] Tom and to make a relationship between that table to your Manager dimension. thats way you will have to make only 1 RLS rule. you can read more about it here:
http://radacad.com/dynamic-row-level-security-with-profiles-and-users-in-power-bi
So, RLS is set in both the Desktop and the Service. For each set of branches, you will need to first create a role, so 50 roles. So, your RLS rule will look like something along the lines of:
Table[Branch] = 12
This would be the rule for Branch12 for example.
Then you publish your file to the Service. In the Service you can then add members to each of the roles. So, you would add Tom to the Branch12 role, for example.