Incremental Refresh with Dataverse as Datasource

Kiran1234 · ‎10-25-2021

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 · ‎10-25-2021

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 · ‎10-27-2021

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

lbendlin · ‎10-26-2021

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.