Forum Discussion
How can I save records before refreshing my data ?
Ideally you take snapshots with some ETL such as SSIS or scheduled program.
If this is not possibel you could do it in PowerbI using R.
An R transformation could snap the data and save as a file, you can then load a folder of files and use the filename to to ensure you know when it was snapped.
# 'dataset' holds the input data for this script filename <- cat("C:\\temp\\myFile", format(Sys.time(), "%Y%m%d_%H%M"), ".csv", sep="") #write.csv(dataset, file = filename ) output <- datasethttps://docs.microsoft.com/en-us/power-bi/desktop-r-in-query-editor
Thanks for your answer stretcharm, I am going to dig further on this, this looks like it could work in my case,
And thanks nickchobotar, I have found some more info on this, and that is definitely an interesting approach!
Hi mperrot,
If you think the replies are useful, please mark them as answer. So that more people will learn new things here. If you haven't, please feel free to ask.
Thanks,
Angelia