'How to load only select files in power BI desktop

Power BI Desktop has support for loading single parquet file from ADLS,

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,

it loads the json and crc files too in the subfolder,

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

Solution 1:^[1]

You can filter based on Extension in Power Query

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

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source
Solution 1	sai vineeth