Help needed with API access token refresh!!

[sqlguru448]

Hello Folks,

I am completely new to the API calls and M code, please help me to resolve the access token refresh issue.

I am trying to create a function in Power BI query editor to refresh the access token for an API call and I get error saying

"DataSource.Error: Web.Contents failed to get contents from 'https://login.microsoftonline.com/common/oauth2/token/' (400): Bad Request
Details:
DataSourceKind=Web
DataSourcePath=https://login.microsoftonline.com/common/oauth2/token
Url=https://login.microsoftonline.com/common/oauth2/token/  "

below is the M code

let
body = "grant_type=password&resource=https://analysis.windows.net/powerbi/api&client_id=******&username=**@**.com&password=*****",

Data=Web.Contents("https://login.microsoftonline.com/common/oauth2/token/",
[
Headers=[#"Content-Type"="application/x-www-form-urlencoded"],
Content=Text.ToBinary(body)
])
in
Data

Can you please shed some light or help me out in fixing the above error.

Thank you

[Anonymous]

Hi @sqlguru448 ,

You could refer the topics which have the same issue.

https://community.powerbi.com/t5/Desktop/Bad-Request-in-Power-Query/m-p/20471 

Best Regards,

Jay

[sqlguru448]

Anybody, please help?