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
Memorable MemberIdeally 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!