Search code examples
excelpowerbipowerqueryparquetm

Power Query Editor - Import .Parquet File


How can I convert an imported .parquet file correctly, using Excel's Power Query Editor?

Are there drivers available for this in Excel?

enter image description here


Solution

  • You can use the inbuilt connector in Power BI:

    https://learn.microsoft.com/en-us/power-query/connectors/parquet

    let
        Source = Parquet.Document(File.Contents("C:\xxx\userdata1.parquet"), [Compression=null, LegacyColumnNameEncoding=false, MaxDepth=null])
    in
        Source
    

    In Excel, I believe you need a 3rd party connector.

    https://www.cdata.com/drivers/parquet/excel/