Azure data lake dynamic files picking automatically

[raja_94]

Hi all 

My source is azure data lake gen2 

I have one folder in data lake in that folder files like this week 1 data

Week 2 data

Week 3 data

Every Friday one new file updated  in the same folder

I was already implemented  report based on week1 data

But I need for the same report  week 2 and week 3 etc 

And also I need one weeks filters in dashboard 

Once user selects particular week number  automatically that total report and tables we want showing the corresponding week data only.

[amitchandak]

@raja_94 , One way to use that folder and take all the files.

The second is to pick up the latest file https://medium.com/@wkrzywiec/getting-data-from-the-latest-file-in-a-folder-using-power-query-51dfa4...