Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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"
Hi @Svetlin
Is it incomplete when you load it in Power Query or in the model as well?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.