Skip to main content
Microsoft Idea

Power BI

Needs Votes

Set "Build"-permission for a dataset programmatically

Vote (15) Share
Tom Scheuermann's profile image

Tom Scheuermann on 02 Mar 2021 15:36:53

In our workspace in PowerBI service there is a shared dataaset.

The users for this workspace are changing very often, so I created a script in PowerShell to process a list of users and grant them "View" permissions to the workspace.

Now we found out, that users additionally need a "build"-permission granted on a shared dataset - otherwise they are not able to export data to excel (see Build permission for shared datasets - Power BI | Microsoft Docs).

Currently it is not possible to grant the "build"-permission by REST-API and / or PowerShell.
I think it would be useful if this can be done programmatically in the future.

Comments (1)
Tom Scheuermann's profile image Profile Picture

Martijn Coolen on 10 Jun 2022 12:08:40

RE: Set "Build"-permission for a dataset programmatically

it seems this makes it possible to set the build permission:

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/put-dataset-user-in-group

Using "datasetUserAccessRight""ReadExplore"