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
v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
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

 

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?

 

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

 

This article may be helpful: Power BI reading Parquet from a Data Lake - Simple Talk (red-gate.com)

 

Best Regards,
Community Support Team _ Jing

If this post helps, please Accept it as Solution to help other members find it.