topic Re: Set the Host header my Power Query in Developer

Set the Host header my Power Query

RobHess05 — Wed, 27 Mar 2024 11:04:37 GMT

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

Re: Set the Host header my Power Query

Anonymous — Thu, 28 Mar 2024 07:03:57 GMT

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.

Re: Set the Host header my Power Query

RobHess05 — Tue, 02 Apr 2024 14:24:05 GMT

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.

Re: Set the Host header my Power Query

lbendlin — Tue, 02 Apr 2024 20:47:51 GMT

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

Re: Set the Host header my Power Query

RobHess05 — Tue, 02 Apr 2024 23:07:10 GMT

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?

Re: Set the Host header my Power Query

lbendlin — Tue, 02 Apr 2024 23:18:20 GMT

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