Load many Parquet files from Azure Data Lake Gen 2

[gerritlob]

Hey,

I create parquet files in the following structure on an Azure Datalake Gen 2 via a ADF/synapse Dataflow:

root
| - cost_files
    |- 2022
    |  |- 12
    |. |   |- cost_file_1.parquet
    |. |   |- cost_file_2.parquet
    |  |- 11
    |      |- cost_file_1.parquet
    |      |- cost_file_2.parquet
    |      |- cost_file_3.parquet
    |- 2023
       |- 01
          |- cost_file_1.parquet
          |- cost_file_2.parquet

 Now I want to load all the files into my PowerBI dashboard from that folder cost_files. But how can I do that because there are also more files in the same container.

BR G