Forum Discussion

ibutur's avatar
ibutur
Frequent Visitor
9 years ago

A web API key can only be specified when a web API key name is provided.

Hi guys,   I'm trying to connect to a database on Klipfolio. I'm using my ID as explained here: https://klipfolio-api-reference-guide.readme.io/docs/data-source-instances-data so, it's https://ap...
akashgera's avatar
akashgera
Helper I
5 years ago

Hi ImkeF 

I need your help in executing the below query which will generate the access token using power query.

After executing the above query it throws as error: webcontents failed to get contents from the given URL

Doing the same in Postman and giving the proper response, check the screenshot below

Pls help!!

ImkeF's avatar
ImkeF
Community Champion
5 years ago

Hi akashgera ,

to troubleshoot I'd recommend to:
- record the web traffic that is generated by the Postman call and the call via Power BI Desktop. (I always use Fiddler for this task, but there are other optionas as well)

- analyse the differences. Maybe it's due to the headers?
- to troubleshoot problems when refreshing in the service, read this: 

http://blog.datainspirations.com/2018/02/17/dynamic-web-contents-and-power-bi-refresh-errors/

 

  • akashgera's avatar
    akashgera
    Helper I
    5 years ago

    Thanks for the response, I am not much familiar with fiddler but after checking with fiddler, it is showing result-200, Response Header: HTTP/1.1 200 Connection Established