How to get all the data from all the folder uploaded into Power BI from Azure Data Lake.

[DeepDive]

Hi Experts,

I have CSV files available there in AZURE Data Lake.

Structure of data  =  1. Folder  > 2.Year Folder >> (Month- sub Folder)  .. in month folder CSV files are there.

Is there anyway I can get data from all the month folders available there and next month it automatically pics all the data too.

I facing the problem ..if I put last row (for month folder in Power query editor).. how it will save previos month data automatically.

example -- I have 1- 9 month total data available and 10 th month's MTD. I can manually add 1 to 9 and latest files from 10, but what to do in 11th month, because 1-9 and manually added and for latest now it will  take 11th month, then what about 10th month, it will get missed…pls help

[v-lid-msft]

Hi @DeepDive ,

Do you have the same data model struction in all of the CSV files? Are you purpose to combine them one by one in the time order?

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DeepDive]

Hello,

Within month folders there are multiple files like customer table, product table, transaction table etc. from each month table I have to pick lates version of each table..ie. customer, transaction, product etc.