Forum Discussion

Kiran1234's avatar
Kiran1234
Frequent Visitor
4 years ago

Incremental Refresh with Dataverse as Datasource

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.

3 Replies

  • Kiran1234's avatar
    Kiran1234
    Frequent Visitor

    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.

  • 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.

  • Kiran1234's avatar
    Kiran1234
    Frequent Visitor

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