Import data from excel and append data into another table

Hi Anonymous - the question I have - how is Excel erasing and replacing the data each day?  Ideally, Power BI/Power Query would connect to the original source rather than the Excel.

You could consider changing this daily process to take of copy the file/data before erasing and replacing so you have the daily backup for the history to import into Power Query while maintaining the current file process.  Power Automate can help with this scenario - copy the excel file then start the Power BI refresh.

Note - Power BI incremental load features (in the dataset or dataflow) could also help to read the current file and append to the previous loads.  While this is an option, I would hesitate to use because the Incremental Load will not be able access the history to reload the previous partitions should it break.  I have tried something like this in the past, but it breaks.  A good backup strategy is hard to implement.