Forum Discussion

abedkhooli's avatar
abedkhooli
Frequent Visitor
9 years ago

Get data from web error: A web API key can only be specified when a web API key name is provided

I have PBI desktop Version: 2.40.4554.463 64-bit (October, 2016) and I am trying to get web data from opensensors using an API with a key. I tried several combinations in the header (one is shown bel...
Need Help
Show and Tell
mllopis's avatar
mllopis
Community Admin
9 years ago

Hi all,

 

In order to be able to supply an “Api Key” via the credential UI, the user’s M has to look like this:

 

Web.Contents(URL, [ApiKeyName="mykey"])

 

If the user enters a key of SECRET, this will produce a final URL of URL?mykey=SECRET

 

NOTE: this is not supported in cloud refresh.

 

With respect to other messages on the thread,

  1. There’s no way to set arbitrary HTTP request headers through the credential system.
  2. There’s no way to get arbitrary HTTP response headers

 

Hope this helps.

BrentonC's avatar
BrentonC
Helper I
3 years ago

"NOTE: this is not supported in cloud refresh."

Can you point me towards the documentation that says this? I have been trying to get this working for a while, although have not come across this in the documentation. It could have saved me some time. 

https://learn.microsoft.com/en-gb/powerquery-m/web-contents