Is there a size limitation to unpacking of gzip files

[Svetlin]

Hi there,

I have a rather large gzip file 300MB (unzipped is about 3.4GB) containing a csv data file. I use the code below to unpack the file. Content loads, but it's uncomplete, about an 8th of what it should be. No errors, nothing.

Are there any limitations to the gzip files allowed to be loaded ?

Any other ideas/suggestions?

Thanks... 

let
SourceCompressed = File.Contents("D:\gzipTest\testGzipFile.csv.gz"),
Source = Csv.Document(Binary.Decompress(SourceCompressed, Compression.GZip),[Delimiter=",", Encoding=1252, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true])
in
#"Promoted Headers"

[Mariusz]

Hi @Svetlin 

Is it incomplete when you load it in Power Query or in the model as well?

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

[Svetlin]

Hi @Mariusz ,

Thanks for your response...

Data is partialy loaded in the model too - both on Desktop and when the report is deployed to the Power BI service.

When data refresh is triggered on the Desktop, the loading counter gets to about 75MB and closes the pop-up window, as if all completed successfully. When deployed to the Power BI service, data refresh also finishes successfully.

In both instances, the same records are loaded.

Regards:

Svetlin