Forum Discussion
timestamping data to another table
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 th...
Power BI doesn't do this well just now - it focuses on extraction, transformation, analysis and presentation of data than on data storage. If you can do it in your data source, it may work better. To help improve this area, vote for this idea and add any relevant comments: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7288623-incremental-data-loads
For a workaround, see this post from Imke Feldmann: http://www.thebiccountant.com/2016/02/09/how-to-create-a-load-history-or-load-log-in-power-query-or-power-bi/ Note that you can now call R from Power Query, so you should no longer need the call to "plot" in the example shown there. And there is a link to a newer non-R version towards the botom of that post.