Forum Discussion
Set the Host header my Power Query
My API has a requirement to set the Host in the header, but Power BI throw an error when I try:
The code looks good, and works if I set other values in the header. It just throws an error if I set the Host. What's the best way to do this?
Source = Value.Metadata(Web.Contents("https://www.borat.net/wp-json/wp/v2/posts?_fields=date,modified,link,title,author,comment_status,status&per_page=100&orderby=modified&order=desc", [ Headers = [#"Host" = "www.borat.net"] ])),
Hi RobHess05 ,
Based on my understanding, this issue may now still be related to the API can't be run successfully with this host name. Please first try to run the API with the host correct value in the third party tool Post Man until successfully get the response, then you can try to run the same API request in the same format (same header and body) in the Power query:
Postman API Platform | Sign Up for Free
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
let Source = Value.Metadata(Web.Contents("https://www.beringer.net", [Headers=[Referer="www.beringer.net"]])) in SourceThank you. Power BI does accept Referer, but I need to use 'Host' in the Header.
Here's my Postman example with Host in the header, which returns a header with very specific attributes
Here's my example with Referer in the Header
I need to pull that value out of the header to handle paging. Does Power BI allow 'Host' in the header?
5 Replies
Hi RobHess05 ,
Based on my understanding, this issue may now still be related to the API can't be run successfully with this host name. Please first try to run the API with the host correct value in the third party tool Post Man until successfully get the response, then you can try to run the same API request in the same format (same header and body) in the Power query:
Postman API Platform | Sign Up for Free
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for the reply Anonymous . Yes, this works well in Postman.
Here's the actual let query that throws the error in Power BI:
let Source = Value.Metadata(Web.Contents("https://www.beringer.net/wp-json/wp/v2/posts?_fields=date,modified,link,title,author,comment_status,status&per_page=100&orderby=modified&order=desc", [ Headers = [#"Host" = "www.beringer.net"] ])),and here's the working Postman request
It's an open API, so you should be able to reproduce the error if you try my query from Power BI.
let Source = Value.Metadata(Web.Contents("https://www.beringer.net", [Headers=[Referer="www.beringer.net"]])) in SourceThank you. Power BI does accept Referer, but I need to use 'Host' in the Header.
Here's my Postman example with Host in the header, which returns a header with very specific attributes
Here's my example with Referer in the Header
I need to pull that value out of the header to handle paging. Does Power BI allow 'Host' in the header?