Forum Discussion
raja_94
4 years agoFrequent Visitor
Azure data lake dynamic files picking automatically
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.
1 Reply
- amitchandakSuper User
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-51dfa4bff711