Forum Discussion
How to manage data restatements?
You need to just bring in and append each of the last 4 quarters. It's simply not true at all that Power BI/Power Query is not prepared to handle this scenario. Many of us append millions and millions of rows of data as a matter of course, with perfectly fast performance. Further, if you set up your query to return just the last 4 quarters, I don't see why you'd need to repeat this every quarter.
--Nate
But my issue is that it isn't as simple as just appending data to my existing data. If I do that, I will be adding duplicates. Every quarterly data drop includes a new quarter of data but it also includes restated data for the previous 3 quarters making updates to the data previously distributed.
Not sure if I am articulating this well, but I cannot just append each quarterly data drop to the existing data. I have to replace existing data as well.