Set the Host header my Power Query

[RobHess05]

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"] ])),

[v-yangliu-msft · Accepted solution]

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.

[lbendlin · Accepted solution]

let
    Source = Value.Metadata(Web.Contents("https://www.beringer.net", [Headers=[Referer="www.beringer.net"]]))
in
    Source

[RobHess05]

Thank you for the reply @v-yangliu-msft .  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.

[lbendlin · Accepted solution]

let
    Source = Value.Metadata(Web.Contents("https://www.beringer.net", [Headers=[Referer="www.beringer.net"]]))
in
    Source

[RobHess05 · Accepted solution]

Thank 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?

[lbendlin]

Does Power BI allow 'Host' in the header?

apparently not.  If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41

[v-yangliu-msft · Accepted solution]

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.