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.
3 Comments
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/
Agree with both, very much needed.
It would be nice if they could make Web.contents API Key support work in the headers as well as in the URL
- Status added:New
