Forum Discussion
Fetch new and modified records using Power BI Incremental Refresh
How can we configure Power BI Incremental Refresh so that you can fetch the new records and modified records within the defined range?
Currently with Detect Changes option enabled, only modified records are fetched, and with the Detect Changes disabled, only new records that are inserted are fetched.
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.
8 Replies
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)
HI Anonymous,
Does lbendlin's suggestion help? If that is the case, you can consider Kudo or accept his suggestion(if it resolves your issue) to help others who face a similar scenario to find it more quickly.
If these also not help, you can feel free to post here with detailed information.
Regards,
Xiaoxin Sheng