Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
I'm trying to connect to an API with this documentation, but I keep receiving an error stating "A web API key can only be specified when a web API key name is provided."
Does anyone have any experieince with this?
I'm using Power Query (via Excel). I tried the Access Web Content menu and then clicked on the API Key option.
Hi @BobS4P
Try Web.connect function in Power Query to connet to API.
From this blog, I think you can try this way to solve the issue.
Step3: In the Access web content dialog, select Basic, enter your app's API key as the Username, and press Connect. This will open the Power BI Query Editor.
Here are some same issues like yours and I hope they could help you.
Issue1: Get data from web error: A web API key can only be specified when a web API key name is provided
Issue2: Connect to restful api data source multiple times
You may refer to this blog:Working with Web Services in Power Query to connect to API by Power Query.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@BobS4P What connector are you using?
 
					
				
				
			
		
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
 
            | User | Count | 
|---|---|
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |