Multiple positions in organizations hierarchy RLS in Power BI server

Hi prajaktakeni11 ,

You can create a calculated column named Hierarchy:

Hierarchy= PATH(Employee[Employee ID],Employee[Parent ID])

 we go to the Manage Roles option, we need to apply the below filter to the Employee Table.

PATHCONTAINS(PATH(Employee[Employee ID],Employee[ParentId]),MAXX(FILTER(Employee,Employee[Employee Name]=USERPRINCIPALNAME()),Employee[Employee ID]))

To configure it at the Power BI Service level, one needs to go to dataset settings – Security  in  the Workspace

Then, we can add the email addresses of the users to the roles.

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.