Skip to main content
Microsoft Idea

Power BI

Under Review

REST API for managing roles of datasets

Vote (394) 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

Abhishek on 05 Jul 2020 23:40:20

RE: REST API for managing roles of datasets

Is there any update on this feature?

Tamás Vidó's profile image Profile Picture

David Fombella on 05 Jul 2020 23:40:13

RE: REST API for managing roles of datasets

Any update on this feature, creating roles manually in powerbi desktop is weird if you have 100 or 500 roles

Tamás Vidó's profile image Profile Picture

Laura J on 05 Jul 2020 23:39:29

RE: REST API for managing roles of datasets

Any update on this feature request? Are you done discussing it internally, Jono Luk (Admin, Microsoft Power BI)?

Tamás Vidó's profile image Profile Picture

C. Augusto Proiete on 05 Jul 2020 23:33:01

RE: REST API for managing roles of datasets

Any update on this feature request? This is critical to enable continuous deployment of reports

Tamás Vidó's profile image Profile Picture

Power BI User on 05 Jul 2020 23:18:22

RE: REST API for managing roles of datasets

I would really need this feature to generate the security constrains based on my ERP security structure

Tamás Vidó's profile image Profile Picture

David Perez on 05 Jul 2020 23:15:35

RE: REST API for managing roles of datasets

Any status with this feature? Was the API modified to support managing roles?

Thanks,
David Perez

Tamás Vidó's profile image Profile Picture

josh on 05 Jul 2020 23:14:15

RE: REST API for managing roles of datasets

I'm in the same boat as Eric. I need RLS setup for datasets created by the API. Is there an update on this?

Tamás Vidó's profile image Profile Picture

Erik on 05 Jul 2020 23:13:49

RE: REST API for managing roles of datasets

Is there any update on this feature request?

I need to only allow access to data through RLS based on regions an admin user can dynamically add/delete/alter in our application. In order to do this I need to be able to create/delete new roles programmatically as our client's admin creates/deletes these regions.

Without this feature there isn't a workable solution that I can see

Tamás Vidó's profile image Profile Picture

Florian Schäffler on 05 Jul 2020 23:08:01

RE: REST API for managing roles of datasets

'Until the API has been extended for programmatically adding roles, there's the following workaround.

- create a stock of unused roles and users once within Power BI Desktop and publish those with the report
- in your application keep track of which role has been already used
- on a new sign-up to your application get one of the available role/user
- update the underlying data for existing and new entries to comply with the chosen role/user

Tamás Vidó's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:00:37

RE: REST API for managing roles of datasets

I would also really like this functionality. I agree with the last comment it is prone to mistakes. I have to open my pbix file and add the roles and then i have to reload my BPIX file (i use the API to do this and it's awesome). but if I had this functionality I wouldn't have to interact with the file ever again after the inial creation of the reports.
Are there any updates?