Fetch new and modified records using Power BI Incremental Refresh

[Anonymous]

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.

[Anonymous]

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

[lbendlin]

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

[Anonymous]

@lbendlin  What difference does it make if you enable or disable the Detect Changes option? 

[lbendlin]

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)

[Anonymous]

@lbendlin 

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.

[lbendlin]

Can you confirm that your Detect Changes column is different from the column filtered by RangeStart and RangeEnd?

[Anonymous]

Yes the columns are different.

[lbendlin · Accepted solution]

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.