Forum Discussion
Is anyone successfully using Incremental Refresh?
Thanks - so do your fact tables include rows that get updated? Mine do. In my testing, the engine was loading the fresh rows, but not deleting the prior versions of those rows (again, based on a PK). The documentation mentions nothing at all about primary keys, and my testing confirms that there is no notion of replacing a row with its current, updated version.
Hi ctmullins,
if the date values relevant for incremental refresh can change, then it's way more complicated. Power BI is not able to track these changes and will indeed mess up data in a simple setup.
You might be able to utilize the "Detect data changes" setting. You'd need to add a [last changed] column to the fact table. And you'd need to make sure to always trigger the incremental update in the correct date ranges by updating [last change] accordingly.
It's a bit more complicated, but it's still possible to make it work this way.