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
