A web API key can only be specified when a web API key name is provided.

[ibutur]

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?

[nnosaj]

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. 

[ericOnline]

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!

[chrisu]

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/.  

[ibutur]

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"