Forum Discussion

joemillson's avatar
joemillson
Frequent Visitor
4 years ago

Dataverse - Issue with incremental refresh / query folding and RangeStart conversion

Hi - I have a simple query from Dataverse, which I would like to have incremental refresh, and use the real-time data functionality.

 

I've set up the RangeStart and RangeEnd parameters, and the query steps are showing the View Native Query option. However, when I try to set up the incremental refresh, I get the error about inability to determine if query folding is possible. So I have looked at the native query info and seen that the parameter dates are being converted into a format which doesn't match the filter column.

 

The filtered column is dd-mm-yyyy hh:mm:ss, and the RangeStart and RangeEnd parameters are set up as this, however are being converted to yyyy-mm-dd.

 

Any help would be much appreciated.

 

Joe

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    "I get the error about inability to determine if query folding is possible"

    That is not an error, it is only a warning.  Incremental refresh will still work

     

    Are you trying to implement a "normal"  incremental refresh where all partitions are in import mode, or a new "hybrid tables" model with a direct query connection in lieu of the "youngest"  partition? 

  • joemillson's avatar
    joemillson
    Frequent Visitor
    4 years ago

    I am trying to use new hybrid tables with direct query for the youngest partition. The option to use direct query is greyed out due to the issue with folding.