topic Automate Row Level Security (RLS) permissions on the portal in Developer

Automate Row Level Security (RLS) permissions on the portal

Anonymous — Fri, 24 Apr 2020 11:37:53 GMT

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!

Re: Automate Row Level Security (RLS) permissions on the portal

Greg_Deckler — Fri, 24 Apr 2020 12:02:48 GMT

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/889567

Re: Automate Row Level Security (RLS) permissions on the portal

Anonymous — Thu, 30 Apr 2020 07:41:57 GMT

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!

Re: Automate Row Level Security (RLS) permissions on the portal

bknowles — Thu, 23 Sep 2021 17:46:04 GMT

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?