Forum Discussion

RobHess05's avatar
RobHess05
Helper I
2 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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's avatar
    lbendlin
    2 years ago
    let
    Source = Value.Metadata(Web.Contents("https://www.beringer.net", [Headers=[Referer="www.beringer.net"]]))
in
    Source
  • RobHess05's avatar
    RobHess05
    2 years ago

    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?

RobHess05's avatar
RobHess05
Helper I
2 years ago

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.

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago
    let
    Source = Value.Metadata(Web.Contents("https://www.beringer.net", [Headers=[Referer="www.beringer.net"]]))
in
    Source
    • RobHess05's avatar
      RobHess05
      Helper I
      2 years ago

      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?