Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

New Power Bi API Endpoints for Managing Dataset Users

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 ?

1 ACCEPTED SOLUTION

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.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Attaching the screenshots:

API Permissions:

sreejithsreekum_0-1656967046022.png


Dataset Access for SPN:

sreejithsreekum_1-1656967095867.png

 

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors