Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.