Set the Host header my Power Query

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
    Source

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?