Skip to main content

Power BI

Under Review

REST API for managing roles of datasets

Vote (396) Share
Tamás Vidó's profile image

Tamás Vidó on 27 Apr 2016 20:56:42

Row-level security enabled by roles for datasets feature released in March 2016. is great but a manual process. It should be enabled via Rest API too. That would allow synchronization of user roles with custom applications automatically.

Administrator on 21 Jun 2022 07:26:05

We’ve acknowledged it and we want to do it but we don't have a timeline to share yet

Comments (53)
Tamás Vidó's profile image Profile Picture

Tom Puckett on 01 Jun 2021 15:26:48

RE: REST API for managing roles of datasets

Pleeeeeease, at least let me get a list of roles with an API.

Tamás Vidó's profile image Profile Picture

Rubén Trujillo on 20 May 2021 14:53:20

RE: REST API for managing roles of datasets

Really looking forward to this

Tamás Vidó's profile image Profile Picture

Moses Castellano on 26 Apr 2021 14:53:25

RE: REST API for managing roles of datasets

It would really help if you could implement this. This is the only manual step we have left to resolve until we have complete automation for one of our pipelines.

Tamás Vidó's profile image Profile Picture

Siwei Chen on 14 Apr 2021 10:03:30

RE: REST API for managing roles of datasets

Please make this happen!!

Tamás Vidó's profile image Profile Picture

Wouter Wagemaker on 12 Dec 2020 09:37:19

RE: REST API for managing roles of datasets

Make this happen, Microsoft!!

Tamás Vidó's profile image Profile Picture

Tony V on 03 Nov 2020 19:27:52

RE: REST API for managing roles of datasets

There should be nothing you can do from the website (app.powerbi.com) that you can't do from the API. I accept that there may a lag between website availability and API availability, but all functionality should either be implemented or be on the product roadmap.

Tamás Vidó's profile image Profile Picture

Christoph Sauer on 10 Jul 2020 17:20:59

RE: REST API for managing roles of datasets

But you cannot assign members programmatically to a role.

Tamás Vidó's profile image Profile Picture

Ron Pitts on 10 Jul 2020 17:20:37

RE: REST API for managing roles of datasets

You can automate roles via this method https://micatio.com/blog/automate-roles-in-power-bi-desktop/

Tamás Vidó's profile image Profile Picture

Srinivasan Rajagopalan on 06 Jul 2020 00:17:21

RE: REST API for managing roles of datasets

Hi Team,
Can we create a Static row level security using power bi?
my requirement is need to 50+ static row level is there any way we can achieve using power bi Rest Api.

Tamás Vidó's profile image Profile Picture

Marshall on 06 Jul 2020 00:13:43

RE: REST API for managing roles of datasets

I have over 100 roles i need to create, and subsequently map said roles to users/groups in the portal.

While I can automate the AAD group creation and membership, the lack of such automation with roles and mapping within Power BI means this is an incredibly painful and time consuming task that is very difficult to manage. Any benefit gained by RLS is ruined by this overhead. I cant see this being used by enterprise companies outside of basic reporting.