topic Re: API calls no longer working in Developer

API calls no longer working

kirby — Wed, 27 Jun 2018 02:03:31 GMT

Hi there

I have been using the auth URL below to authenticate against the Power BI API (Using Powershell) for months now and yesterday it just stopped working

https://login.microsoftonline.com/common/oauth2/token

I now receive the error:

The remote server returned an error: (400) Bad Request.

I have tried to debug the call in Postman and it appears the grant_type parameter is not being validated correctly. Even though it is specified, I always receive the error:

Please could this be investigated as none of my Power BI refreshes are currently running

Thanks a lot

Re: API calls no longer working

v-jiascu-msft — Thu, 28 Jun 2018 05:53:34 GMT

Hi @kirby,

That might be the changes or the issues of AAD. According to the #use-the-authorization-code-to-request-an-access-token, the grant_type should be authorization_code. Please check it out. Please also refer to the below posts for the similar approaches.

1. https://community.powerbi.com/t5/Developer/programmatic-data-refresh-using-api/m-p/223051#M7045

2. https://community.powerbi.com/t5/Developer/Authentication-in-Powershell-and-API-to-update-a-dataset/td-p/229470

3. https://docs.microsoft.com/en-us/power-bi/developer/walkthrough-push-data-get-token

Best Regards,

Dale

Re: API calls no longer working

kirby — Thu, 28 Jun 2018 07:39:04 GMT

Hi Dale

Thanks a lot for the info. I did visit most of these sites yesterday but without any luck. I tried the same thing now and it seems to be working

Thanks again

Cheers