Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Web Contents Error - Section=ResponseHeader Detail=CR must be followed by LF

Hi there, can anyone help with the below error. Can't get anything to import or find a workaround. Have tried a couple of things such as adding " cookies="ignore", useUnsafeHeaderParsing="true"  " but no luck. I'm using office 365. 

 

Full error is

 

DataSource.Error: The server committed a protocol violation. Section=ResponseHeader Detail=CR must be followed by LF

 

Code is

 

 

let
    Source = Json.Document(Web.Contents("https://content.sb.danskespil.dk/content-service/api/v1/q/events-by-ids?marketIds=106715310&includeChildMarkets=true&includePriceHistory=false&includeCommentary=false&includeMedia=false", [Timeout=#duration(0, 0, 0, 2), Headers=[Language="en-US", #"User-Agent"="Mozilla/5.0", cookies="ignore", useUnsafeHeaderParsing="true"]]))
in
    Source

 

 

 

 

 

Need Help

1 Reply

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous ,

     

    Which version of Power BI Desktop are you using?

     

    I test your code with 2.91.701.0 64-bit (March 2021) and 2.91.884.0  64-bit (March 2021). No error occurrs.

     

    Please install the latest one and test it again.

     

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.