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.
I have an API that now needs an API key for authentication. I have been trying all morning to get this to work but do not know where in the below I need to set the API Key, can anyone help please as I need to get my report back online as soon as possible?
jsonDoc= Json.Document(
Web.Contents(
"https://**************/api/v1/***/****tory", [RelativePath="/?&start=" & Number.ToText(n)])),
result = jsonDoc[result],
records = result[records],
tmpTbl = Table.FromList(records, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
Thanks
Hi @jdchipps ,
You may try codes like below.
jsonDoc= Json.Document(
Web.Contents(
"https://**************/api/v1/***/****tory", [RelativePath="/?&start=" & Number.ToText(n)], [ApiKeyName="APIToken"]) ),
result = jsonDoc[result],
records = result[records],
tmpTbl = Table.FromList(records, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
For reference:
https://blog.crossjoin.co.uk/?s=web.contents&submit=Search
https://blog.crossjoin.co.uk/2014/03/26/working-with-web-services-in-power-query/
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Your relative path structure is slightly inaccurate. But you can extend it as needed
jsonDoc= Json.Document(
Web.Contents(
"https://**************/api/v1/***/****tory", [RelativePath="/?APIKey=" & key & "&start=" & Number.ToText(n)])),
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
66 | |
34 | |
26 | |
22 |
User | Count |
---|---|
97 | |
96 | |
58 | |
45 | |
42 |