Forum Discussion
RLS for multiple Department Leaders
Hello,
I want to display data on my BI Report based on Department Head so that they can see their subsequent Staff only. Currently, I have created multiple, individual Role for each Department as follows.
Finance Role
[email] = “[email protected]” || [DeptID] = 13
IT Role
[email] = ‘[email protected]” || [DeptID] = 1
Marketing Role
[email] = “[email protected]” || [DeptID] = 3
Is there a more efficient or better way of doing this? Is it better to have 1 Group that can handle all different scenarios? (If yes, how?) Or does it need to be done individually as described above?
Hi bcap01 ,
You can refer the following links to apply RLS for your tables base on your scenario:
What Do You Need to Implement Dynamic Row-Level Security in Power BI?
Dynamic Row Level Security with Manager Level Access in Power BI
RLS based on user's department - of which they can have multiple
Best Regards
4 Replies
Hello, Claro in Azure groups you can easily group and update the permissions of each person
https://powerbi.microsoft.com/fr-ch/blog/azure-active-directory-and-power-bi/Syndicate_Admin Thank you for your reply!
How do I call Azure using PowerBI? For example, I have tried [Department] = "IT" but I get the message, "Column 'Department' cannot be found or may not be used in this expression."
Is there some DAX syntax I need to consider?
Hi bcap01 ,
You can refer the following links to apply RLS for your tables base on your scenario:
What Do You Need to Implement Dynamic Row-Level Security in Power BI?
Dynamic Row Level Security with Manager Level Access in Power BI
RLS based on user's department - of which they can have multiple
Best Regards
Hi bcap01 ,
Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.
Best Regards
