Forum Discussion

Joseph_11's avatar
Joseph_11
Frequent Visitor
3 years ago
Solved

Error in Incremental load

Hello All, I was trying to implement Incremental load. But I wasn't sure where Iam going wrong I have created parameter(RangeStart and RangeEnd) and filtered the date column based on the parame...
Data Protection
  • v-jialluo-msft's avatar
    v-jialluo-msft
    3 years ago

    Hi Joseph_11  ,

     

    There can be only one equal to.

    The type of the parameter should be Date/Time, please fix and then test.

     

     

     

    Best Regards,

    Gallen Luo

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-jialluo-msft's avatar
v-jialluo-msft
Community Support
3 years ago

Hi Joseph_11 ,

 

If a table configured with incremental refresh does not support query folding, the goal of incremental refresh cannot be achieved.

Most data sources that have the concept of a query language support query folding. These data sources can include relational databases, OData feeds (including SharePoint lists), Exchange, and Active Directory. However, data sources like flat files, blobs, and web typically do not.
Query folding - Power Query | Microsoft Learn

 

Best Regards,

Gallen Luo

  • Joseph_11's avatar
    Joseph_11
    Frequent Visitor
    3 years ago

    Hi v-jialluo-msft 

    Got your point..Thanks for sharing your content.

    In the below screenshot till renamed columns query folding is available and it got broken after the following steps

    Is it possible to enable query folding for this step(Filtered rows), Since the above steps are created by my senior colleagues I don't want to make any changes it the steps.

    Regards,
    Joseph