Power BI Role Base Access

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.