Connect daily updated data files to the source

[Anonymous]

Hi all,

I'm new to Power BI and have the following issue: I have a data source (daily sales) and every day I get previous day sales delivered as seperate Excel file. I were just copying new data to the data source file, connected to PowerBI model. But it is pretty annoying to do it every day and Excel source quickly becomes overloaded with data. Is there a way to connect a folder with all daily updated Excel files? Currently I have no idea where to get started with this issue. Thanks! 

[amitchandak · Accepted solution]

@Anonymous , check these

https://powerbi.tips/2016/06/loading-data-from-folder/

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

[Anonymous]

that's what I was looking for! thanks a lot!