powerbiazure-blob-storageparquetpowerbi-desktopazure-data-lake

How to load only select files in power BI desktop


Power BI Desktop has support for loading single parquet file from ADLS, enter image description here

Right now our process will dump multiple parquet files into a folder. The folder will have sub folders with files of other format like json or crc

My issue is I want to give folder as input and only load the parquet files.

If I try with the connector for ADLS Gen 2, enter image description here

it loads the json and crc files too in the subfolder, enter image description here

How can I selectively ignore and only load .parquet files?


Solution

  • You can filter based on Extension in Power Query

    let
        Source = Folder.Files("Location"),
        FilteredData = Table.SelectRows(Source, each ([Extension] = ".parquet"))
    in
        FilteredData