Forum Discussion
Solved
How can I save records before refreshing my data ?
Power BI community, I need your insights.. I have data coming from a CRM, they are tickets, open or closed. Everytime I refresh, some of the open tickets besome closed obviously. But in the analy...
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
nickchobotar
Skilled Sharer
Skilled Sharer
There is a data modeling concept called "Slowly Changing Dimension" . This is a data modeling technique that allows to manage current and historical data over time. You will need to have start and end timestamps of yours tickets in order to implement this approach.
N -