Forum Discussion
Creating custom HTTP request header with WebApi as datasource
Hi, I have an WebAPI that is secured with Windows authentication. I am trying to add custom header parameter (and value) when connecting to the API but get an error as shown in the screenshot. Is...
Hi tejakpa,
Can you share us your formula to test? It will be help for troubleshooting.
BTW, the parameters which used in http header should match the config of api, if you use a unknown parameter it may caused the issue.
Reference link:
M Query to use POST method on a Web API
Regards,
Xiaoxin Sheng
As I said in my original query, I am not interested in typing the request body and come up with a 'formula'. I see that power BI allows adding optional header parameters (in 'advanced' options tab after selecting 'web' as datasource before making the api call so I would just like to add the key-value pairs and have it work out of the box.