Forum Discussion

jnh3_powerbi's avatar
jnh3_powerbi
New Member
5 years ago
Solved

Parquet file with Snappy compression on ADSL Gen 2

We have files in our Azure Data Lake Storage Gen 2 storage account that are parquet files with Snappy compression (very common with Apache Spark). I don't see any menu option for reading those, so af...
Need Help
Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
5 years ago

Hi @jnh3_powerbi 

 

Currently Binary.Decompress only supports Compression.GZip and Compression.Deflate types. It doesn't support Compression.Snappy. See Binary.Decompress - PowerQuery M | Microsoft Docs

 

From Parquet format - Azure Data Factory & Azure Synapse, I see that gzip type is supported. Is it possible to compress the files to gzip in ADLS Gen 2?

21091601.jpg

 

Additionally, Parquet connector is currently available in Power Query Desktop. Maybe you can try this connector. 

21091602.jpg

 

Best Regards,
Community Support Team _ Jing