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
lukaszp's avatar
lukaszp
Power BI Team
9 years ago

This question is a litle beyond my M mastery :) mllopis and TPalmer could you help?

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.

  • Sokon's avatar
    Sokon
    Advocate V
    9 years ago

    Obviously, there was no OData feed-Connector available in earlier versions of PBID, right?

    Because now, there is one - which doesn't mean much, because the error stays the same:

    I would expect the build-in editor is able to compose correct API-Queries. If so, what do I do wrong? (Not many options here, right)

  • 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