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 i...
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/
