Refresh - API GOOGLE ANALYTICS

[juliovidigal]

Good afternoon!

I'm making a call in google analytics api, to refresh my token.

In powerbiDesktop, it works perfectly, in 2 modes!
But when I publish this in app.powerbi.com it returns me error.

Any idea?

let

app_credentials ="client_id=XXXXXXm&client_secret=XXXXXX",

url = app_credentials & "&refresh_token=" & "xxxxxxxx" & "&grant_type=refresh_token",
GetJson = Web.Contents("https://www.googleapis.com/oauth2/v4/token",
[
Headers = [#"Content-Type"="application/x-www-form-urlencoded"],
Content = Text.ToBinary(url)
]
),
FormatAsJson = Json.Document(GetJson)[access_token]
in
FormatAsJson

Return this error: Failed to update data source credentials: Web.Contents failed to get contents from 'https://www.googleapis.com/oauth2/v4/token' (404): Not Found

And

let

app_credentials ="client_id=XXXXXXm&client_secret=XXXXXX",

url = app_credentials & "&refresh_token=" & "xxxxx" & "&grant_type=refresh_token",
GetJson = Web.Contents("https://accounts.google.com/o/oauth2/token",
[
Headers = [#"Content-Type"="application/x-www-form-urlencoded"],
Content = Text.ToBinary(url)
]
),
FormatAsJson = Json.Document(GetJson)[access_token]
in
FormatAsJson

Return this error: Failed to update data source credentials: Web.Contents failed to get contents from 'https://accounts.google.com/o/oauth2/token' (405): Method Not Allowed

[v-shex-msft]

Hi @juliovidigal,

Current power bi service not support custom function and query parameters. I think your issue may related to it.(these parameters not available on power bi service, so your methods get the error or wrong result)

Regards,
Xiaoxin Sheng