Forum Discussion

ABR002's avatar
ABR002
Icon for Helper I rankHelper I
2 years ago
Solved

Binary error when trying to link zip file on web

Trying to import the CVE zip file into power query (https://github.com/CVEProject/cvelistV5/archive/refs/heads/main.zip)   I’ve tried various solutions found on this board, such as: Unzip and load...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    That ZIP file is (way, way) too big for the solutions you have tried.  Anything over 2 GiB will not read reliably. Your content is over 4GiB and has gazillions of files and folders. The solutions mostly expect single file payloads.

     

    Download and extract the ZIP manually and then use the Folder connector to ingest the CVEs.

     

     

    let
    Source = Folder.Files("C:\Users\xxx\Downloads\cves"),
    #"Removed Other Columns" = Table.SelectColumns(Source,{"Content", "Name"}),
    #"Added Custom" = Table.AddColumn(#"Removed Other Columns", "Title", each Json.Document([Content],1252)[containers][cna][descriptions]{0}[value])
in
    #"Added Custom"
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

That ZIP file is (way, way) too big for the solutions you have tried.  Anything over 2 GiB will not read reliably. Your content is over 4GiB and has gazillions of files and folders. The solutions mostly expect single file payloads.

 

Download and extract the ZIP manually and then use the Folder connector to ingest the CVEs.

 

 

let
    Source = Folder.Files("C:\Users\xxx\Downloads\cves"),
    #"Removed Other Columns" = Table.SelectColumns(Source,{"Content", "Name"}),
    #"Added Custom" = Table.AddColumn(#"Removed Other Columns", "Title", each Json.Document([Content],1252)[containers][cna][descriptions]{0}[value])
in
    #"Added Custom"