Forum Discussion

jnh3_powerbi's avatar
jnh3_powerbi
New Member
4 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 after searching around I tried the following with Power Query M:

let
Source = AzureStorage.DataLake("https://oursa.dfs.core.windows.net/ourfiledir/"),
ContentColumnTable = Table.SelectColumns(Source,{"Content"}),
DecompressedContentTable = Table.TransformColumns(ContentColumnTable,{"Content",(x) => Binary.Decompress(x,Compression.Snappy)})
in
DecompressedContentTable

While the first 2 statements seem to work OK, when I add the decompression line I get the following error:

Expression.Error: Invalid compression type.
Details:
2

However, I got that compression type directly from the documentation: Compression.Snappy - PowerQuery M | Microsoft Docs

 

Is there something wrong with the code, or does Power BI not implement all of the PowerQuery functionality? 

2 Replies