Forum Discussion
Get data from web error: A web API key can only be specified when a web API key name is provided
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
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.
2 Replies
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.
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.
