RLS for multiple Department Leaders

[bcap01]

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] = “johndoe@test.com” || [DeptID] = 13

IT Role

[email] = ‘janendoe@test.com” || [DeptID] = 1

Marketing Role

[email] = “joedoe@test.com” || [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?

[v-yiruan-msft]

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

[v-yiruan-msft · Accepted solution]

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

[bcap01]

@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?

[Syndicate_Admin]

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/