Forum Discussion

thomas_pike's avatar
thomas_pike
Frequent Visitor
7 years ago
Solved

Ingesting multiple gzip files

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?

  • Anonymous's avatar
    Anonymous
    7 years ago

    thomas_pike ,

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

    Regards,
    Lydia

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    thomas_pike ,

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

    Regards,
    Lydia