https://community.fabric.microsoft.com/t5/Dataflow/How-to-fix-Dataflow-Gen2-error-quot-Failed-to-verify-that-a/m-p/4399034#M4828 <LI-CODE lang="markup">I have incremental load enabled on "lastmodifieddate" (datetime data type).</LI-CODE> <P>Incremental Refresh is incompatible with data changes.&nbsp; You need to choose a datetime column with immutable values like "createddate".</P> Fri, 07 Feb 2025 00:53:32 GMT lbendlin 2025-02-07T00:53:32Z https://community.fabric.microsoft.com/t5/Dataflow/How-to-fix-Dataflow-Gen2-error-quot-Failed-to-verify-that-a/m-p/4398357#M4826 <P>When connecting to BC365 custom/advanced API (salesInvoiceLines) through a Dataflow Gen2, I get the error&nbsp;"Failed to verify that a query with incremental refresh is folding" upon publishing.</P><P>&nbsp;</P><P>How to fix? I have incremental load enabled on "lastmodifieddate" (datetime data type).</P><P>&nbsp;</P><P>Here are my query steps (basically I first navigate to salesInvoices (the parent) after which I expand/unpivot data for salesInvoiceLines):</P><P><img /></P><P>Incremental refresh settings:</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Thu, 06 Feb 2025 14:33:58 GMT https://community.fabric.microsoft.com/t5/Dataflow/How-to-fix-Dataflow-Gen2-error-quot-Failed-to-verify-that-a/m-p/4398357#M4826 useruserhi91 2025-02-06T14:33:58Z https://community.fabric.microsoft.com/t5/Dataflow/How-to-fix-Dataflow-Gen2-error-quot-Failed-to-verify-that-a/m-p/4399034#M4828 <LI-CODE lang="markup">I have incremental load enabled on "lastmodifieddate" (datetime data type).</LI-CODE> <P>Incremental Refresh is incompatible with data changes.&nbsp; You need to choose a datetime column with immutable values like "createddate".</P> Fri, 07 Feb 2025 00:53:32 GMT https://community.fabric.microsoft.com/t5/Dataflow/How-to-fix-Dataflow-Gen2-error-quot-Failed-to-verify-that-a/m-p/4399034#M4828 lbendlin 2025-02-07T00:53:32Z