I have a csv file which I load at the end of the month. This file contains all transactions from 2018 to the end of December 2019. In this file, some tickets may be re-open or closed let’s say at the middle of any month. We want to be able to load the changes when we do the next upload.
Now we want to load January 2020 data. What we have done is download all the data again from 2018 to 31st of January 2020, this will enable us capture all the changes that has happened within the period and replace the initial file from 2018 to December 2019. Then refresh the file in Power BI.
I am wondering if there is a better way of capturing just what has changed in the old file and just add any changes that has occurred in Power BI instead of replacing the file from old to new each month.
Hope this makes sense.