Get Access Token

[ayazbedrekar]

As per below video , need to update the token every 1 hour & write the query accordinlgy but 
https://www.youtube.com/watch?v=cTqFNg_y9lw&list=PLL-WSn9hvefogtxxi7CJhjLCJvrDY0mpQ 

But In blank query :  Get access token.

********************************************************************************************************
let
body = "grant_type=password&resource=https://analysis.windows.net/powrebi/api&client_id=ourTenantId&username=abc@xyz.com&password=abcd",
Data= Web.Contents("https://login.microsoftonline.com/common/oauth2/token/",
[
Headers=[#"Content-Type"="application/x-www-form-urlencoded"],
Content=Text.ToBinary(body)

])

in
Data
******************************************************************************************************************
 we are getting problem with trying to access data from API service & getting below error.
DataSource.Error: Web.Contents failed to get contents from (400): Bad Request

so request you please let me know is there any change in query, resource link or web link or script? Could you help me build this function or share some example?

please findbelow screen shot.

already gone throgh below links:

https://community.powerbi.com/t5/Developer/REST-API-Get-Access-Token/m-p/1895937#M29924 

https://community.powerbi.com/t5/Developer/Power-BI-REST-API-using-postman-generate-embed-token/m-p/... 

[Anonymous]

Hi @ayazbedrekar ,

Any updates?

Best Regards,
Eyelyn Qin

[Anonymous]

Hi @ayazbedrekar ,

Below is an answer provided in a similar thread, please refer to

And there is are serveral links posts on Web.Contents() / how to connect to REST API via OAuth2 in Power BI. Please check if these could help you a little.

https://chris.koester.io/index.php/2015/07/16/get-data-from-twitter-api-with-power-query/

400: Bad Request in Power Query RRS feed 

Web.Contents(), M Functions And Dataset Refresh Errors In Power BI 

If you still get error, you can use Fiddler to track the process following the guide in this video.

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