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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

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
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.