Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello friends, hoping you are well.
I have an api rest that can only be called by the methodo post and in Power BI Desktop I have no problems, but when wanting to have an updated programming in service I have problems.
This is my advanced editor to consume the api.
let
fechaI = Date.ToText(DateTime.Date(DateTime.LocalNow()),"yyyy-MM-dd'T'HH:mm:ss"),
fechaT = Replacer.ReplaceText(fechaI,"T00:00:00","T23:59:59"),
url = "url api",
body = "{""apiKey"":""api key"", ""inicio"":"""&fechaI&""", ""termino"":"""&fechaT&""", ""identificador"": null}",
Source = Json.Document(Web.Contents(url,[
Headers = [#"Content-Type"="application/json"],
Content = Text.ToBinary(body)
]
)),
in
Source
Then he asks me for a web credential where I can put Anonymous and make it public.
So far so good.
Then I publish my report but when I want to have a scheduled update, I have that error.
I already tried installing and reviewing my gateway and nothing please help.!!!!!!!!!!!!!!!!!!!!!!!!
Solved! Go to Solution.
Hi @ldroguett ,
It seems like detail REST API url not allow you to use anonymous authorizations on it. If this is a case, I'd like to suggest you to add relative path option to convert rest api url to root path and relative path.
let Source=Web.Contents("https://xxxx.xxxxxxx.com",[Headers = [#"Content-Type"="application/json"],Content = Text.ToBinary(body),RelativePath="/api/xxxxxxx"]) in Source
Regards,
Xiaoxin Sheng
Hi @ldroguett ,
It seems like detail REST API url not allow you to use anonymous authorizations on it. If this is a case, I'd like to suggest you to add relative path option to convert rest api url to root path and relative path.
let Source=Web.Contents("https://xxxx.xxxxxxx.com",[Headers = [#"Content-Type"="application/json"],Content = Text.ToBinary(body),RelativePath="/api/xxxxxxx"]) in Source
Regards,
Xiaoxin Sheng
Thanks !
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.