Power BI Desktop "Get Data" using Web Option (API Pull) Details: "Web.Contents failed to get content

[Anonymous]

Hey All!

I need some help with using the Get Data -> Web feature of power bi desktop. i enter in my credentials for my user account for the site (formsite.com) but it gives me the following error:

This is what my credentials window looks like:

And here is the link window when putting in my link i wish to use to connect (it is the API link handed out by my website):

I have tried using just connecting to an API key, but thats telling me the following:

i literally just copy and pasted the key that is being shown (Well in the site its labeled as the Account Access token, but my experience with this is minimal so i might be mixing this up for something else)

would any of you fine folk know whats going on here?

Thanks!

[Anonymous]

Thank you for the Reply!

so i tried the first solution, it gave me the same 404 error, i am unsure of how to utilize power query and i do not have access to Azure function proxy. Would you happen to know of any other solutions?

Thanks!

[amitchandak]

@Anonymous , refer if this can help

https://community.fabric.microsoft.com/t5/Desktop/quot-A-web-API-Key-can-only-be-specified-when-a-web-API-key-name/td-p/2739227

[Anonymous]

also i found that this is a new message that comes up when trying to use Power Query:

Would you know where to go from here?

Thanks!