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

Try your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now

Reply
s_taylor
New Member

Connect to data source via API

Hello, I'm trying to connect to a data source via a REST API.

 

I'm entering this: https://[[server]]/products/api/ and when prompted enter my key. I keep getting the error "A web API key can only be specified when a web API key name is provided".

 

I'm not sure what key name should be provided, or where.

 

A few posts on here recomment Chris Webb's article, but I don't think I was following it properly.

 

My expectation is that I should be able to connect via the API, and have a list of fields appear by magic - but maybe I'm fundamentally misunderstanding it?

 

Thanks,

Simon

1 REPLY 1
amitchandak
Super User
Super User

@s_taylor , is API key means OAUTH, or a popup, for OAUTH refer https://www.poweredsolutions.co/2017/01/24/connecting-to-apis-with-power-bi-power-query-part-1-of-2/

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Fabric Data Days is here Carousel

Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.