Incremental Copy Job error from NetSuite

Hi  jacob9hawkes ,

Thankyou for reaching out to Microsoft Fabric Community and thanks to ati_puri for providing meaningful insights.

It looks like the error is happening when Fabric builds the incremental filter for the watermark column and the NetSuite ODBC driver tries to interpret the datetime value.

Could you check whether the copy job completes if it is set to a full load with incremental refresh turned off? If that works, it would point to the generated watermark predicate rather than a connectivity or table access problem.

Please also confirm that the watermark column is surfaced as a native DateTime/Timestamp field in SuiteAnalytics Connect, not as a calculated or text-based field. It may also be worth checking the NetSuite ODBC driver version on the gateway machine, since driver-specific SQL translation issues can sometimes impact incremental loads.

If the problem continues across multiple tables with valid datetime watermark columns, it may indicate a compatibility issue between Fabric's generated incremental query and the NetSuite ODBC driver, and the next step would be to open a support ticket.
For Reference;
Incremental copy in Copy job - Microsoft Fabric | Microsoft Learn

To create a Fabric or Power BI support ticket, please refer to:

https://learn.microsoft.com/en-us/power-bi/support/service-support

 Best Regards,

Abdul Rafi.