Incremental Refresh with Dataverse as Datasource

[Kiran1234]

Incremental refresh is not working with Dataverse even when the query folding is enabled. Even when the record is deleted that falls outside of the date range, record is not seen in the power query and performing full refresh.

[Kiran1234]

Incremental refresh is not working with Dataverse even when the query folding is enabled. Even when the record is deleted that falls outside of the date range, record is not seen in the power query and performing full refresh.

[Kiran1234]

filter parameters RangeStart and RangeEnd have been used in the Power Query.

[lbendlin]

for the first issue you will want to confirm that your Power Query code includes a filter command that uses both RangeStart and RangeEnd.

The second issue is more complex.  What you need is differential refresh, not incremental refresh.  As a workaround you need to increase the update window.