Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
Anonymous
Not applicable

Automate Row Level Security (RLS) permissions on the portal

Hi, 

 

I have a report with RLS applied working fine and I'm sure that there is a way to add new users to the Dataset Row-Level security in an automatic way using an API or so?

I would like to avoid the dependency of adding new users as they come in several places, so this could be really useful for me.

Has someone done this before?

 

Thanks in advance!

 

3 REPLIES 3
bknowles
Regular Visitor

I'm looking for a solution to this, too.

 

I'm just in the implementation stage right now, but we have 8 security groups and 3 datasets right now.  I know we're going to have more security groups as more departments find out about our dashboards.

 

Does anyone have any automation scripts or ways to load a security file?

Greg_Deckler
Community Champion
Community Champion

I actually don't see anything here: https://docs.microsoft.com/en-us/rest/api/power-bi/

Perhaps you should be using dynamic RLS? https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Hierarchical-Row-Level-Security/td-p...


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

Hi,

 

Thanks for the answer, but I don't think that's what I'm looking for. This dynamic security thing seems to be applied in the Model itself, applying DAX queries and what I need is to add a new user in the Dataset of the web portal.

 

Thanks anyway!

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors