topic Re: New Power Bi API Endpoints for Managing Dataset Users in Developer

New Power Bi API Endpoints for Managing Dataset Users

Anonymous — Mon, 04 Jul 2022 20:24:58 GMT

Hello,

I have a working application where I am able to create a workspace, add user/group to workspace, upload a pbix file to workspace etc. But for adding/giving user permission specific to a workspace, I was manually doing the Datasets - Manage Permissions section.

Now, I came to notice that we have new endpoints available for this purpose.

Datasets - Get Dataset Users - REST API (Power BI Power BI REST APIs) | Microsoft Docs

Datasets - Post Dataset User - REST API (Power BI Power BI REST APIs) | Microsoft Docs

I tried with an existing workspace and also I created a new workspace by passing workspacev2 flag as true. In both cases, I am not able to consume these endpoints. I am getting a 403 - "API is not accessible for application" error.

I have reverified the App permissions from the Azure portal and the permission scopes suggested in the above links are already there. I am having the SPN as Dataset(owner) also.

Can you please help me if there is something else I should do ?

Re: New Power Bi API Endpoints for Managing Dataset Users

Anonymous — Mon, 04 Jul 2022 20:38:48 GMT

Attaching the screenshots:

API Permissions:

Dataset Access for SPN:

Re: New Power Bi API Endpoints for Managing Dataset Users

Anonymous — Thu, 07 Jul 2022 07:57:32 GMT

Hi @Anonymous ,

According to your second screenshot, I think your application should be a Service Principal. As far as I know, we don't need to granrt API Permissions in Azure portal like normal applications. I think we need to create a security group and add Service Principal as a member in group.

Then trun on both permissions in Power BI Tenant Setting.

Embed content in apps
Allow service principals to use Power BI APIs. (We need to add security group into this permission.)

And we need to add Service Principal as a member/admin in that workspace.

For reference:

Embed Power BI content with service principal and an application secret

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.