Skip to main content

Power BI

Needs Votes

REST API for managing roles of datasets

Vote (257) 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.

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

3358f9f1 c9c1-449c-943e-e2b93c5747b8 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

6ac9a309 56e7-4f3e-a16d-7092a87e9d1a 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

de44c4ee 032c-477f-8027-c6c245c6e026 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

f9ce71fd d3d1-4e9a-979c-7676975c9082 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.

Tamás Vidó's profile image Profile Picture

73d706d2 962a-4ce8-a111-1db2178146a5 on 06 Jul 2020 00:13:05

RE: REST API for managing roles of datasets

Is there any update on this feature available?

Tamás Vidó's profile image Profile Picture

a685c815 8961-4ebf-8547-34de73ac5a51 on 06 Jul 2020 00:11:37

RE: REST API for managing roles of datasets

I fully agree that if we want to manage roles on data set we should have an API for that or may to propose it in the Power BI portal through an administration tool enabling the management of a huge number of roles for a large scale deployment.
This feature is powerfull but today it's difficult to deploy it.

Tamás Vidó's profile image Profile Picture

fe65dbcc 62c9-4bd6-b435-01f805da6401 on 06 Jul 2020 00:11:33

RE: REST API for managing roles of datasets

Hi, It's realy a big effort to manage this point manually on large scale deployments. Is there any update?

Tamás Vidó's profile image Profile Picture

0fedea6d 57c0-428d-b13b-1bfccd41dc23 on 06 Jul 2020 00:11:31

RE: REST API for managing roles of datasets

I'm also interested with that because security is a blocking point.

Tamás Vidó's profile image Profile Picture

ee5a6928 3da9-4f19-9bc4-b32669ad0b77 on 06 Jul 2020 00:11:29

RE: REST API for managing roles of datasets

As somebody else already said: This is really needed, any update on this will be helpful.

Tamás Vidó's profile image Profile Picture

24737f28 6d34-46a7-ac74-b206fa8a0409 on 06 Jul 2020 00:09:05

RE: REST API for managing roles of datasets

This is really needed, any update on this will be helpful.