Forum Discussion

aliphonse80's avatar
aliphonse80
New Member
4 years ago

Connecting PowerBI "A web API key can only be specified when a web API key name is provided"

I am trying to get powerBi to pull data from:
https://api.wifisensorcloud.com/


I have been going over all the api documentation and reviewing powerbi support forums and I cannot get powerbi to pull the JSON

The supplier have given me the API Key, but I get the following error: “A web API key can only be specified when a web API key name is provided”

 

 

BELOW ARE THE INFORMATION FROM SUPPLIER

Connecting to the API The 5 services are hosted at:

https://api.wifisensorcloud.com/Users.svc

https://api.wifisensorcloud.com/Locations.svc

https://api.wifisensorcloud.com/Devices.svc

https://api.wifisensorcloud.com/Sessions.svc

https://api.wifisensorcloud.com/Lookups.svc

 

Connections using any protocol other than https (such as http) will be rejected. Requests for data should use the GET method with parameters supplied in a query string whereas data submissions/updates should use the POST method with parameters supplied in a JSON object. Examples of each of these methods are on the next pages.

 

Need Help

1 Reply

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    4 years ago

    Hi aliphonse80 

     

    Sorry I'm not familar with JQuery AJAX GET method so I'm not sure how to pass the key/value pairs in the "data" parameter to a Get request. Maybe you can try something like below for a Get request to the API:

    If you have a key for authentication, it may need to be passed in the request header of a Get request. 

     

    Best Regards,
    Community Support Team _ Jing

Related content