Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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"