RLS with Multiple roles to single user - See Report data as per role

[ashishpbi]

Hello,

Scenario:

I am implementing security (RLS) where one user belongs to multiple Roles (i.e., Office-1 and Level-1). Therefore, if the user see the report -1 (for Office-1) , the data for Office1 should be visible and if the user see report-2 (for Level-1) the data for Level-1 with all offices including Office-1 should be visible. No data duplicity or combined data should be visible on both reports.

Query:

How can i switch between roles in the Report ? For example the user can select the role from a dropdown field and accordingly the role should be visible to the user. Kindly share how can this be implemented or if Roles can be configured in realtime while accessing the reports.

Can someone guide or share some approaches ?

[ashishpbi]

Is there a way to manage such scenario of multple roles assigned to a single user.

Are there any options in case the reports are accessed using Live Connection mode ?

[rajendraongole1 · Accepted solution]

Hi @ashishpbi - Create two different reports: One for Office-1 with RLS for Office-1 and another for Level-1 with RLS for all offices.Assign the user to multiple roles via Power BI security settings, and the role will automatically apply depending on which report they are accessing.This ensures no data duplication or overlap in the RLS implementation while keeping access controlled.

reference links:

Dynamic Row Level Security in Power BI with Organizational Hierarchy and Multiple Positions in Many-...

solved thread:

Solved: Dynamic RLS with 2 different roles - Microsoft Fabric Community

Hope this helps.

[ashishpbi]

This only works for reports created independently. The solution do not work in the normal cases where the reports are connected to single Model or through Live connection (Azure Analysis Services).

The query is to display the data differently to the same user, as per the different Role configured in the Model.

Or, how can a user switch between 2 roles within the same report ?