Forum Discussion
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.
-
Hi Pker_Tank,
Thank you for reaching out to Microsoft fabric community forum! Akash_Varuna has provided a great suggestion on using a User Access Table for managing Row-Level Security (RLS). I would like to add a few words.
Instead of managing multiple security groups, you can use a User Access Table to dynamically control access. This approach allows managers to assign temporary access without IT intervention.
If this helps, then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.
Thank you.
Hi Pker_Tank,
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.