Skip to main content

Power BI

New

Securely Authenticate with an API key in the headers

Vote (14) Share
Michael Marbut's profile image

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)
Michael Marbut's profile image Profile Picture

Martin Smith on 05 Oct 2022 20:18:13

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/