topic Re: Connecting with API Key in Developer

Connecting with API Key

BobS4P — Fri, 28 May 2021 19:11:29 GMT

I'm trying to connect to an API with this documentation, but I keep receiving an error stating "A web API key can only be specified when a web API key name is provided."

Does anyone have any experieince with this?

Re: Connecting with API Key

Greg_Deckler — Fri, 28 May 2021 19:17:24 GMT

@BobS4P What connector are you using?

Re: Connecting with API Key

BobS4P — Fri, 28 May 2021 19:20:23 GMT

@Greg_Deckler

I'm using Power Query (via Excel). I tried the Access Web Content menu and then clicked on the API Key option.

Re: Connecting with API Key

Anonymous — Mon, 31 May 2021 09:26:43 GMT

Hi @BobS4P

Try Web.connect function in Power Query to connet to API.

From this blog, I think you can try this way to solve the issue.

Step3: In the Access web content dialog, select Basic, enter your app's API key as the Username, and press Connect. This will open the Power BI Query Editor.

Here are some same issues like yours and I hope they could help you.

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

Issue2: Connect to restful api data source multiple times

You may refer to this blog:Working with Web Services in Power Query to connect to API by Power Query.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.