Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
1 year ago
Solved

Zip function from MARK WHITE

Hi good day, Can anyone share the query function by MARK WHITE, coz now show error on his page.     Thank you
Need Help
  • 123abc's avatar
    123abc
    1 year ago

    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.

123abc's avatar
123abc
Community Champion
1 year ago

 

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's avatar
123abc
Community Champion
1 year ago

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.