How to give a user multiple RLS Roles

[aqsasaleem]

I have a senario where I have to assign Department Role to a manager. I have multiple departments and multiple managers where  few departments are under one manager so i have to show all those departments data to its manager. how i do that?

[Anonymous]

Hi @aqsasaleem ,

Base on your decrition, you want to assign Department Roles to a manager in Power BI. Specifically, you have multiple departments, and some of them fall under the same manager. You need to ensure that each manager can access data from all the departments they oversee. You can refer the following links to get it.

Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

• Create Roles like “Canada Manager” “Toys Manager ” etc.
• Define Role Filters: Use DAX expressions to filter data based on the manager’s role. For instance:
  If a manager oversees Canada, the filter might be: [Department] = "Canada".
  If a manager oversees Toys, the filter might be: [Department] = "Toys".
• Cross-Filtering: By default, roles are additive. This means that if a user belongs to multiple roles, the filters are combined. If the manager A manage both department Canda and Toys, you can add him in both role “Canada Manager” and “Toys Manager ”

Dynamic Row Level Security with Organizational Hierarchy Power BI - RADACAD

Best Regards

[some_bih]

Hi @aqsasaleem check link for example