Ingesting multiple gzip files

[thomas_pike]

We are trying to ingest multiple gzipped CSV files for a project.  We can ingest a single gzipped file with the following:

let
    Source = File.Contents("C:\Users\username\something.csv.gz"),
    Decompressed = Binary.Decompress(Source, Compression.GZip),
    #"Imported CSV" = Csv.Document(Decompressed,[Delimiter=",", Columns=28, Encoding=1252, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(#"Imported CSV", [PromoteAllScalars=true]),
    #"Changed Type" = ....snipped...
in
    #"Changed Type"

And we can import multiple plain CSV files from a directory using the directory source type.  What I can't figure out how to do is to import multiple gzipped files in a directory.  How do we apply the "Binary.Decompress" to each file in a directory as part of the load?

[v-yuezhe-msft · Accepted solution]

@thomas_pike ,

You can create a function in Power BI Desktop as discussed in this similar thread, then invoke this function.

Regards,
Lydia