Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi everyone
I'm not the hardest coder out there, but normally I can youtube my way through. NOT THIS TIME 😞
I'm trying to access some ticker data from a REST API in json format, with the following string in advanced editor.
= Json.Document(Web.Contents("https://api.coinigy.com/api/v1/data", [ Headers = [#"Content-Type"="application/json",#"X-API-KEY"="6b796808aeddf74791fc85ce03aa276a",#"X-API-SECRET"="5de422bc18e0987fa26d8227a7d442d1"] ] ))
without the header part I get a auth error. With the header part a get a 404 error.
Any suggetions is MUCH appreciated!
Hi @DesrAw,
Your query looks fine. But I keep getting "Invalid API Key" error in my test.
Could you try the query below, then supply an “Api Key” via the credential UI to see if it works?
Web.Contents(URL, [ApiKeyName="mykey"])
Regards
Thank for your answer. Much appreciated!
Yes I altered the API information, because they would give access to sensitive data. 😞
The credential UI will ask for a "username" and "password", correct? The API require "X-API-KEY" and "X-API-SECRET". Will that not be a problem?
Hi @DesrAw,
have you found a solution to that problem? I am having trouble with the exact same problem.
Best,
Pedram
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
68 | |
53 | |
39 | |
33 |
User | Count |
---|---|
71 | |
63 | |
57 | |
49 | |
46 |