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

[useruserhi91]

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 to fix? I have incremental load enabled on "lastmodifieddate" (datetime data type).

Here are my query steps (basically I first navigate to salesInvoices (the parent) after which I expand/unpivot data for salesInvoiceLines):

Incremental refresh settings:

[lbendlin · Accepted solution]

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