Forum Discussion
Fetch new and modified records using Power BI Incremental Refresh
If there are recent data changes in your Detect Changes Column for partitions OUTSIDE of the specified refresh range then those partitions will ALSO be processed.
lbendlin What difference does it make if you enable or disable the Detect Changes option?
Yes, there's much more to it.
Incremental refresh in Power BI - Power BI | Microsoft Docs
Read all the caveats (especially the part where it says it needs to be a different column, and the part where it talks about persisting the data)
Can you provide an explanation for this,
Detect Changes is enabled, when a new record is inserted, it is not fetched, but a record is modified, inserted record is also fetched along with the modified record.
I did go through the link you shared but still I am not getting how exactly this works.
Can you confirm that your Detect Changes column is different from the column filtered by RangeStart and RangeEnd?
Yes the columns are different.