Forum Discussion

useruserhi91's avatar
useruserhi91
Icon for Helper I rankHelper I
1 year ago
Solved

How to fix Dataflow Gen2 error: "Failed to verify that a query with incremental refresh is folding"?

When connecting to BC365 custom/advanced API (salesInvoiceLines) through a Dataflow Gen2, I get the error "Failed to verify that a query with incremental refresh is folding" upon publishing.   How ...
  • lbendlin's avatar
    1 year ago
    I have incremental load enabled on "lastmodifieddate" (datetime data type).

    Incremental Refresh is incompatible with data changes.  You need to choose a datetime column with immutable values like "createddate".