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

[FearDerBeard]

I'm having difficulty making Web.Contents work.  I think anyone can get a key here: https://api.data.gov/signup

Power BI keeps throwing this error.  Has anyone solved this?  I didn't find anything helpful in other posts. ty

let
    Source = Json.Document(Web.Contents("https://api.data.gov/ed/collegescorecard/v1/schools?id=100663&apikey=xxxxxxxxxxxxxxxxxxxxxx",
    [Query=[apikey=" xxxxxxxxxxxxxxxxxxxxxx"]]))
in
    Source

[FearDerBeard · Accepted solution]

Found the answer here:

https://dev.applicationinsights.io/documentation/Using-the-API/Power-BI

"In the Access web content dialog, select Basic, enter your app's API key as the Username, and press Connect"

Hope this helps.

[DavidRobson]

This is no longer working, unfortunately.

I haven't found the solution yet...

The issue for me is that none of the authentication options provided correspond to "api key", as opposed to Power BI Desktop.