Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Error:
An error occurred in the ‘’ query. Expression.Error: 3 arguments were passed to a function which expects between 1 and 2.
Details:
Pattern=
Arguments=[List]
Code used (I'm pretty sure it requires a slight tweak somewhere but I'm not sure where - it works if I remove the bit where I provide API token, however, without the token I cannot access the data, so I just need to figure out how to correctly specify the API key in my Power Query):
(ID as text) as table=>
let
Source = Json.Document(Web.Contents("---MY API ADDRESS---",
[RelativePath ="/api/data/"&(ID)&"/"],
[Headers=[#"X-API-KEY"="9999999999999999"]]
))
#"Converted to Table" = Record.ToTable(Source),
#"Pivoted Column" = Table.Pivot(#"Converted to Table", List.Distinct(#"Converted to Table"[Name]), "Name", "Value")
in
#"Pivoted Column"
Solved! Go to Solution.
Hi @Redraidas10
1.May you can refet to the following code
e.g
Source = Json.Document(Web.Contents(PARAM_API_BASE_URL, [RelativePath = "/project/testprj", Headers = [Authorization = "Basic " & Binary.ToText(Text.ToBinary(PARAM_API_USERNAME & ":" & PARAM_API_USER_PASSWORD), BinaryEncoding.Base64), #"APIKey" = PARAM_API_KEY]]))
And you can refer to the following link.
Accessing REST APIs with Basic Auth and API Key in Power Query | John Dalesandro
2.You can try to the following solution.
a.select "Web" in get data in Power BI Desktop.
b.input the URL in basic.
3.Select the "Web API" to access and input your key.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Redraidas10
1.May you can refet to the following code
e.g
Source = Json.Document(Web.Contents(PARAM_API_BASE_URL, [RelativePath = "/project/testprj", Headers = [Authorization = "Basic " & Binary.ToText(Text.ToBinary(PARAM_API_USERNAME & ":" & PARAM_API_USER_PASSWORD), BinaryEncoding.Base64), #"APIKey" = PARAM_API_KEY]]))
And you can refer to the following link.
Accessing REST APIs with Basic Auth and API Key in Power Query | John Dalesandro
2.You can try to the following solution.
a.select "Web" in get data in Power BI Desktop.
b.input the URL in basic.
3.Select the "Web API" to access and input your key.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.