Forum Discussion
Import data from excel and append data into another table
Hi, I'm receiving daily excel files with a table in which a field shows the extraction date of the data. I want to keep track of all data and store all historical values into a data model to make s...
Hi Anonymous - there are many YouTube videoes with example. Here is one Combining Multiple Files from a folder using Power Query in Excel or Power BI - YouTube
Many thanks Anonymous but it is slightly more complex than that. There is only one excel file that is fed constantly with daily data and then erased the following day and replaced by today's data and so on. If I retrieve data from this file I'd see day 1 data. The following day day 2 data. And so non. But how to consolidate day 1 & 2 in the same table even if the file is changing every day? I was hoping to do that with a PowerQuery script.