Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
aliphonse80
New Member

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”

 

Screen shot.jpg

 

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.

 

Screen shot from supplier.jpg

1 REPLY 1
v-jingzhang
Community Support
Community Support

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:

vjingzhang_0-1661935846661.png

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors