Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper II
Helper II

Bulk add users to RLS Role



My client has over 5000 users. Each user is mapped to a specific location and can only see data for his particular locations. This is naturally done through the user_security table. 

The RLS works, but I wonder how can I add those users to the role on the service in a bulk?

Can it be done or it needs to be done manually?

If we do it via AD group, do we still need the dim_security table?





Community Champion
Community Champion

Please refer Solved: Assigning RLS roles in bulk - Microsoft Power BI Community


If this post helps, then please consider Accept it as the solution and give it a thumbs up

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors