Forum Discussion
useruserhi91
Helper I
Helper IHow 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 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:
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".
1 Reply
- lbendlin
Super User
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".