Forum Discussion
Solved
Power BI Role Base Access
Hello guys, I hope you are well !! I need your help on this. So, I have five users. A, B, C, D, and E. Each user will have access to the Power BI report but will only see his/her data. This is ...
Hi Pker_Tank , Could you try these steps
Create an Access Table: Set up a table with User ID , Manager ID , and Assigned User columns for easy access management.
Implement Dynamic RLS: Use DAX to dynamically control access, allowing managers to view their data and others' based on assignments.
This will make manager role easier
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance
Hi Pker_Tank ,
-
User Access Table Approach
- Store user emails and role mappings in a dedicated table.
- Use DAX filters to dynamically control data access.
- Allows managers to modify access without IT involvement.
-
Implementation Steps
- Create a User Access Table with User Email, Role, and Assigned Data.
- Apply RLS filters using LOOKUPVALUE() or USERPRINCIPALNAME().
- Ensure access updates dynamically without modifying security groups.
-
Hi Pker_Tank ,
-
User Access Table Approach
- Store user emails and role mappings in a dedicated table.
- Use DAX filters to dynamically control data access.
- Allows managers to modify access without IT involvement.
-
Implementation Steps
- Create a User Access Table with User Email, Role, and Assigned Data.
- Apply RLS filters using LOOKUPVALUE() or USERPRINCIPALNAME().
- Ensure access updates dynamically without modifying security groups.