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

[joemillson]

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

[joemillson]

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.

[lbendlin]

"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?