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.
What you are looking for is differential refresh (a la Lotus Notes), not incremental refresh. Power BI does not support differential refresh yet.
Here's a potential alternative: Incremental Refresh with Slow-Changing Source Data - Microsoft Power BI Community
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.