timestamping data to another table

---

sdeleener wrote:

Hi,

 

I would like to monitor an evolution of my data. Therefore i would need to copy my data from one table/query to another table/query on a daily base and add a timestamp (time & date)

 

In this way i can make a new visual on how my data has been evolving over time.

 

Previously i was using a VBA script in excel for this that refreshes my data on a daily base and copies the lines to a new table. this however not very solid. Is there an option by using some scripts in the query editor of PowerBI?

---

Power BI uses a "delete and reload" paradigm.  It sounds like your data can change each day and you want to keep a snapshot of your data from each day.  If you have an new extract each day, you can simply load each of the daily extracts into Power BI with a suitable time stamp coming from the extract file date.  You can read about this general technique here http://exceleratorbi.com.au/combine-excel-workbooks-power-query-method-1/