Forum Discussion

Elitlogik's avatar
Elitlogik
Frequent Visitor
2 years ago

Binary.Decompress possible error?

Binary.Length(Web.Contents("https://epss.cyentia.com/epss_scores-current.csv.gz"))   Returns 1391340   Binary.Length(Binary.Decompress(Web.Contents("https://epss.cyentia.com/epss_scores-current.c...
Need Help
Elitlogik's avatar
Elitlogik
Frequent Visitor
2 years ago

Hi, thank you for your response.

 

The Gzipped CSV from cyentia.com is what I want to fetch and analyze in Power BI.

Downloading it manually, Unzip with 7zip and open in Excel works fine.

Using the code in the original post results in a table with only one row.

 

Isn't it strange that a Compressed file is 1.4 MB compressed and 63 characters Decompressed?

jennratten's avatar
jennratten
Super User
2 years ago

That particular compression method is very old and is limited in bits.  

  • Elitlogik's avatar
    Elitlogik
    Frequent Visitor
    2 years ago

    I understand. You mean that the Binary.Decompress with the Compression.GZip parameter is old code? Because GZip as a standard is still vewry widely used on the web.

     

    Strangely enough it decompresses another 8 MB file from another source just fine.