Forum Discussion

tejakpa's avatar
tejakpa
Regular Visitor
9 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

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

  • tejakpa's avatar
    tejakpa
    Regular Visitor
    9 years ago

    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.