Forum Discussion

blairtoews's avatar
blairtoews
New Member
4 years ago
Solved

Ignoring Incremental Refresh Warning - Query Folding

Hello, I know many have asked questions surrounding the "Unable to confirm if the M query can be folded..." warning when setting up incremental refresh.  Hopefully this question is not redundant: ...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    You're good.  Not having query folding may slightly increase the processing overhead when partitions are rearranged at the date interval boundaries (new year, new quarter etc) to move data from hot to warm to cold partitions. 

     

    In Datasets you can apply the RangeStart/RangeEnd filter as soon as it makes logical sense in your query. If you already do it in the native query then that is optimal.  Unfortunately this cannot be applied the same way in dataflows.

lbendlin's avatar
lbendlin
Super User
4 years ago

You're good.  Not having query folding may slightly increase the processing overhead when partitions are rearranged at the date interval boundaries (new year, new quarter etc) to move data from hot to warm to cold partitions. 

 

In Datasets you can apply the RangeStart/RangeEnd filter as soon as it makes logical sense in your query. If you already do it in the native query then that is optimal.  Unfortunately this cannot be applied the same way in dataflows.