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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.