![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 44%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
46,190 questions
The error you're encountering typically arises when Power BI does not receive the API key name. Ensure that you correctly include both the API key and the API key name in your request. For Azure API Management, the header name for the API key is often "Ocp-Apim-Subscription-Key", but you should verify the exact name required by your specific API.
In some cases, users create a Power Query function to authenticate and call the authentication URL. This function retrieves the bearer token, which is then used in subsequent queries. An example of such a function includes creating a token combining the API key and making a web request to the authentication URL.
If you're still encountering errors, double-check the accuracy of your API key and key name. Additionally, make sure that the API endpoint URL is correct and that the API is accessible.
for further details
you can check the following discussion:
https://community.fabric.microsoft.com/t5/Power-Query/Web-API-Key-Authentication/td-p/2389219
https://community.fabric.microsoft.com/t5/Desktop/Get-Data-through-API/m-p/369917