Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
ABR002
Helper I
Helper I

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 csv from web - error "we didn't rec... - Microsoft Fabric Community
Solved: Re: How to connect Azure DevOps REST API in to pow... - Microsoft Fabric Community

I keep getting a binary error. Either it can’t convert to binary or:

DataFormat.Error: There was a problem reading the binary format at position 405777492.  The end of the input was reached before the value could be read.

 

What am I doing wrong?

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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.

 

lbendlin_0-1723505354448.png

 

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"

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

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.

 

lbendlin_0-1723505354448.png

 

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"

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors