The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hey everyone,
I need to program a schedule but i use dynamic data so i need to use Relative Paths, when i try to do that with the code under i got the error
Expression.Error: Se han pasado 3 argumentos a una función que espera entre 1 y 2.
Detalles:
Pattern=
Arguments=[List]
The param url contains something like this "730214/runs/3246632"
let
content = "{
""method"": ""post"",
""body"": {}
}",
Origen = Json.Document(Web.Contents( "https://test.com/test/",
[RelativePath = url & "/reports/cookie-privacy"],
[Headers=[#"content-type"="application/json", Authorization="Bearer " &#"GetToken"()],
Content=Text.ToBinary(content)])),
#"Convertido en tabla" = Record.ToTable(Origen)
in
#"Convertido en tabla"
Thanks for your help
Hi @yebenesPW I don't understand the need for "url" in the relativepath. What does url contain? It is possible that Power is generating the following web call?
https://test.com/test/https://test.com/test//reports/cookie-privacy
This would look better
let
content = "{
""method"": ""post"",
""body"": {}
}",
url = "https://test.com/test",
Origen = Json.Document(Web.Contents( url,
[
RelativePath = "/reports/cookie-privacy",
Headers=[#"content-type"="application/json", Authorization="Bearer " &#"GetToken"()],
Content=Text.ToBinary(content)
]
)
),
#"Convertido en tabla" = Record.ToTable(Origen)
in
#"Convertido en tabla"