How to connect to REST API using Windows Auth when header API key is required

[robchiap]

I'm in the process of writing a power query script to call one of our internal APIs. This service uses Windows Authentication but requires an header named "api-key." Since this is not on the Power BI list of allowed headers for this kind of call, I cannot get things to work. Is there a way to get around this restriction?

[amitchandak]

@robchiap , refer if this solution can help

https://community.powerbi.com/t5/Power-Query/Pull-data-from-a-REST-API-Authentication/td-p/246006

[robchiap]

Thank you for the response, but that solution uses Anonymous authentication. Though I get the same error message as that OP, I'm required to use Windows authentication, which only allows certain headers to be used. 

[v-easonf-msft · Accepted solution]

Hi , @robchiap 

It is recommended to create a support ticket .They may have better advice.

Once you create a support ticket and get any workaround, please kindly share it here for reference.
https://powerbi.microsoft.com/en-us/support/ 

Thanks a lot!

Best Regards,
Community Support Team _ Eason