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

Question

I was trying to get data from a vendor's REST API from Power BI.

When getting data, under Web API, it keeps throwing this error. See attached screenshot.

It is a POST method where you can filter by any field in the response body (yet I'm not passing any this time).

The query I am using to get a response is as below. Sorry I forgot where I found it.

let

    apiUrl = "my_api_url",

    token="my_api_key",

    options = [Headers=[Authorization="Bearer " & token ]],

    result = Json.Document(Web.Contents(apiUrl , options))

in

    #"result"

maulemon · Accepted Answer · 2020-02-22 11:43:08Z

5

You need to include ApiKeyName in your request rather than building up Authorization yourself.

For example:

let Source = Web.Contents(apiURL, [ApiKeyName="mauapikey"]),

Also see Microsoft Documentation or someone's blog post

answered Feb 22, 2020 at 11:43

maulemon

1314 silver badges5 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vickel · Accepted Answer · 2020-12-10 15:54:33Z

1

I recently ran into a similar problem, but was able to find the solution:

If your authorization must be in the header, you were nearly there with your solution. In my case, the authorization was required to be in the header, but utilized Basic Authentication rather than Token. I believe if you do the following to your code, it will work

let

    apiUrl = "my_api_url",

    token="my_api_key",

    options = [Headers=[#"Authorization"="Bearer " & token ]],

    result = Json.Document(Web.Contents(apiUrl , options))

in

    #"result"

The only thing added is the '#' before the Authorization and then surrounding Authorization with double quotes "Authorization".

edited Dec 10, 2020 at 15:54

Vickel

7,9906 gold badges40 silver badges63 bronze badges

answered Dec 10, 2020 at 12:44

amrtdc1

111 bronze badge

Comments

Tanayraj Jhagadiawala · Accepted Answer · 2024-07-23 10:07:24Z

0

Do not try to add API on the WEB API section.

Select the BASIC authentication method and there you have to give the username and password.

here, the username is the account username where you created the API key. And Password is your API key.

For me, this worked.

answered Jul 23, 2024 at 10:07

Tanayraj Jhagadiawala

31 bronze badge

Comments

Claire Furney · Accepted Answer · 2024-09-13 15:53:38Z

0

I had exactly the same error trying to use an API key with a Power BI report referencing an Azure Application Insights REST API.

I got it working by not configuring any credentials in the underlying code, but by selecting "Basic" authentication and then adding the API key from the Application Insights resource in the username field and leaving the password blank.

(Then in Power BI admin dashboard the same worked though it wasn't happy with a blank password - I just added the API key for both username AND password instead.)

answered Sep 13, 2024 at 15:53

Claire Furney

2,3973 gold badges28 silver badges40 bronze badges

Collectives™ on Stack Overflow

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

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related