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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
absmiths
Regular Visitor

Access Datasets using PowerBI REST API from Java

I am trying to access the rest API to refresh a dataset, and I am running into authorization problems.  I need to use an app registration from azure.  I create an Authorization context with my client Id and secret, which works with other azure services, but whatever I do I just get unauthorized.  Here are the details:

 

I have assigned permissions in Azure AD to allow Power BI Service (Power BI), including 'Read and Write all Datasets' and 'View all Datasets'.  When I try to access this rest endpoint, https://api.powerbi.com/v1.0/myorg/datasets, I just get unauthorized.  Am I missing a step here?  I think I need to use this call first so that I can get the guid of the dataset to refresh.

3 REPLIES 3
ausgod
New Member

Was there a resultion for this issue.   I am having the exact same problem.  All documented access has been given and still get unauthorized 

v-micsh-msft
Microsoft Employee
Microsoft Employee

You need to give the App the corresponding permission to access Power BI resources:

Follow the steps below:

Register an Azure AD app to embed Power BI content

https://docs.microsoft.com/en-us/power-bi/developer/register-app

 

Follow the Through Azure Portal part.

 

Regards,

Michael

I went through those steps a couple of different times, and it hasn't worked.  I have tried creating a user using the pbi developer access page and using the azure ad portal directly.  I still only get an 'Unauthorized' response.

 

One part I can't follow is granting the AD permission "Access the directory as the signed in user".  My org prohibits this but it doesn't seem necessary anyway since I am not doing impersonation.  Also, in my case I am using a web API instead of a native application type.  Is this required for accessing the dataset refresh API?

Helpful resources

Announcements
ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.