Zip function from MARK WHITE

[AllanBerces]

Hi good day,

Can anyone share the query function by MARK WHITE, coz now show error on his page.

Thank you

[123abc]

Please follow below coumminty links there these problems have alrady been dissucssed.

Zip function from MARK WHITE - Microsoft Fabric Community

Working With Zip Files in Power Query - Microsoft Fabric Community

[PowerQuery] Decompress .zip Files - Microsoft Fabric Community

I hope this helps!
If you found this answer helpful:

Mark it as the solution to help others find it faster.
Give it a kudo to show your appreciation!
Thank you for being an awesome community member!

[123abc · Accepted solution]

Here’s a general approach to decompress ZIP files in Power Query:

1. Load the ZIP file:

   let
       Source = Binary.Buffer(File.Contents("path_to_your_zip_file.zip"))
   in
       Source

2. Extract the contents:

   let
       Source = Binary.Buffer(File.Contents("path_to_your_zip_file.zip")),
       ZipStart = Binary.Start(Source, 4),
       ZipEnd = Binary.End(Source, 4),
       ZipContents = Binary.Middle(Source, ZipStart, ZipEnd)
   in
       ZipContents

3. Convert the binary data to a table:

   let
       Source = Binary.Buffer(File.Contents("path_to_your_zip_file.zip")),
       ZipStart = Binary.Start(Source, 4),
       ZipEnd = Binary.End(Source, 4),
       ZipContents = Binary.Middle(Source, ZipStart, ZipEnd),
       TableFromZip = Table.FromList(ZipContents, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
   in
       TableFromZip

Copied from AI Tool.

[AllanBerces]

Hi @123abc Thank you very much