RLS Issue

[Ubedulla]

Hi,
I have requirement when Manager logs in he/she should see their data along with their direct reportees. If Employee logs in there should not be any filters applied entire organization data should be accessble. I am maintainig two views 1. Manager view and Employee view in a landing page and using dynamic page navigation. And Manager should have access to Manager view as well as Employee view. If Manager navigating to employee view he should all the data there should not be any filters. If Manager is in Manager view he sould his data along with his reportees data.

THanks & Regards,
E Ubedulla.

[v-karpurapud]

Hi @Ubedulla 

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.

[v-karpurapud]

Hi @Ubedulla 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-karpurapud]

Hi @Ubedulla 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-karpurapud]

Hi @Ubedulla 

Thank you for reaching out to the Microsoft Community Forum.

In Power BI RLS applies to the entire dataset and cannot be conditionally turned off per view/page, a workaround is necessary. You can implement dynamic page navigation based on the user's role without relying on RLS.

1. Create a user role table that maps user emails to their roles (Manager or Employee).
2. Create DAX measures to determine which page to navigate to based on the user's role.
3. Create bookmarks for the Manager and Employee view pages. Use buttons or slicers to navigate between these bookmarks based on the user's role.
4. Implement page navigation using buttons with the FX option, allowing you to use the measures created to dynamically navigate to the appropriate page.
   
   

For more detailed information, please refer to the Microsoft official document:

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

If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.

Thank you.

[rajendraongole1]

Hi @Ubedulla  - You can achieve this in Power BI using Row-Level Security (RLS) and Dynamic Page Navigation.

[ManagerID] = USERPRINCIPALNAME() || [EmployeeID] = USERPRINCIPALNAME()

Create a table with navigation option for both manager and employee pages and create below logic with measure

you can add a measure in Power BI to capture user selection

SelectedView =
SELECTEDVALUE(NavigationTable[PageKey], "Employee")

Ref: 

Dynamic Row Level Security with Manager Level Access in Power BI - RADACAD

Applying Page Level Security in Power BI - ClearPeaks Blog

[Ubedulla]

Hi Rajendra,
Thank you for response.
Here scenario is bit differenct. I have Two views Manager and Employee View. If Manager logs in he should see his information when he is on Manager view tab and he should also have access to Employee view. When Manager is navigating to Manager view there should not be any filters applied all the data should be visible. When Employee logs in employee will have access to employee view only and he should see all the data no filters should be applied. 
I have a role column where i can see Manager or Employee. Based on this column I have created two measures to dynamically control pages (Manager and Employee). No issue with dynamic Navigation. but RLS is not removing filters when Manager is navigating to employee view.

Please suggest the solution.