Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys,
I'm trying to connect to a database on Klipfolio. I'm using my ID as explained here:
https://klipfolio-api-reference-guide.readme.io/docs/data-source-instances-data
so, it's https://app.klipfolio.com/api/1.0/datasource-instances/{id}/data
I'm using this as Access web content. But when I enter the API Key in the Web API area, I get the following error message:
A web API key can only be specified when a web API key name is provided.
What does this mean? What do I need to do?
Silly me, actually @ericOnline's solution above worked for me as well. It seems there is currently no direct way to use Azure AD as authentication via the UI. I opted to use API key authentication, but did it the wrong way. So i modified my api to have a custom request header passing the API key, and applied the steps above in my Power BI report.
For what its worth, I just found a good explanation of what this error message is referring to. It appears that when you specify "ApiKeyName = "youapikeygoeshere" " in a PowerQuery, this message will show up.
See this video at the 17:54 mark.
Cheers!
It sounds like you need to specify an API key name in the headers area of Web.Contents using the advanced editor. See Chris Webb's post on this for a good example: https://blog.crossjoin.co.uk/2014/03/26/working-with-web-services-in-power-query/.
Hi, when I add APIToken to the header, I get this error:
Details: "The 'APIToken' header is only supported when connecting anonymously. These headers can be used with all authentication types: Accept, Accept-Charset, Accept-Encoding, Accept-Language, Cache-Control, If-Modified-Since, Prefer, Referer"
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.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |