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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Helper III
Helper III

API Connection errors - Forbidden or needs API Key Name


I'm trying to connect to a new API and in the past I've simply selected 'Get Data from Web' popped in the URL and then the API Key in Web API section to authenticate. 

This time I'm getting an error saying "A web API Key can only be specified when a web API key name is provided". The question is where do I add this? I've tried before the key, after the key, as part of the URL to no avail. 

I've searched the posts and others suggested adding the API Key as the User Name in Basic, but this comes up with a message stating accessing the content is forbidden. 

Any ideas? 

Helper III
Helper III

I've just tried and I can connec to the API in R and see data. 

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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