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.