topic Re: Access Datasets using PowerBI REST API from Java in Developer

Access Datasets using PowerBI REST API from Java

absmiths — Thu, 26 Apr 2018 16:10:12 GMT

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.

Re: Access Datasets using PowerBI REST API from Java

v-micsh-msft — Sun, 29 Apr 2018 01:10:24 GMT

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

Follow the steps below:

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

Follow the Through Azure Portal part.

Regards,

Michael

Re: Access Datasets using PowerBI REST API from Java

absmiths — Mon, 30 Apr 2018 15:40:56 GMT

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?

Re: Access Datasets using PowerBI REST API from Java

ausgod — Wed, 19 Feb 2020 17:22:27 GMT

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