How to get data from multiple files in shared drive and get updated data when I paste a new file?

[kimlien3006]

Hello everybody, 

I have just started working with Power BI and everything is quite confusing to me. So, I have a task: 

I have a dataset including monthly excel reports from 07/2018 to 9/2020 and at the beginning of the month, I will receive the data from the last month. I need to build the report containing the historical data and from October, it can be refreshed and updated the new data added from the new file.  

It means that I need to connect Power BI with the data source (a shared drive containing around 30 Excel files) and it has a way to update the new file when I paste a new Excel file in the shared drive. 

I hope you will get what I mean. Sorry for my bad explanation and looking forward to hearing from you!

Thanks so much!

[Greg_Deckler · Accepted solution]

@kimlien3006 If I am following this correctly, use a Folder query.

[amitchandak · Accepted solution]

@kimlien3006 , there is an option to take data from the folder .

to get latest file refer :https://medium.com/@wkrzywiec/getting-data-from-the-latest-file-in-a-folder-using-power-query-51dfa4...

[Greg_Deckler · Accepted solution]

@kimlien3006 If I am following this correctly, use a Folder query.