Michael Marbut on 16 Feb 2022 16:58:09
In Power BI Desktop there is a way to use Authentication Web API Key which works fine and even submitting a custom ApiKeyName in M Power Query Language works ok. This of course submits the API Key in the URL.
There is a work around if the API requires the API key to be submitted in the headers in M Power Query Language like [Headers = KeyName="Key"] and this works well for what it needs to do, however this leaves the API in an insecure location and cannot be configured to work with automatic refreshes.
If I try configure Web API under Data Source Settings then Web.Contents will not allow a "SEC" header to be set (the required name of my APIKey).
There needs to be a way to configure an API key to be submitted in the headers through the Data Source Settings screen.
- Comments (1)
RE: Securely Authenticate with an API key in the headers
This functionality is sorely needed.For Power Query in Excel I need to be able to share the workbook without also having to share the API key hardcoded into it somewhere. Unfortunately this issue seems to have existed since 2014 https://blog.crossjoin.co.uk/2014/03/26/working-with-web-services-in-power-query/