Sun.Feb 11, 2024

article thumbnail

Reading Parquet Metadata In Power Query In Power BI

Chris Webb BI

There’s a new M function in Power Query in Power BI that allows you to read the data from a Parquet file: Parquet.Metadata. It’s not documented yet and it’s currently marked as “intended for internal use only” but I’ve been told I can blog about it. Here’s an example of how to use it: let Source = Parquet.Metadata(File.Contents("C:myfile.snappy.parquet")) in Source …and here’s an example of the output: This query shows how to expand the recor