KNOWLEDGE BASE

ID field is not recognized as column that will be used to identify new rows for Incremental refresh


Published: 29 Nov 2023
Last Modified Date: 30 Nov 2023

Issue

When configuring an incremental extract refresh, it is not possible to specify an ID field for Identify new rows using column.

Environment

  • Tableau Desktop

Resolution

Check the data type of the ID field, and modify it to be either Number (whole), Date, or Date & Time, or alternatively, specify another available field.

Cause

Only the data type of "Number (whole)", "Date", or "Date & Time" is supported to be used to identify new rows for Incremental refresh.
Did this article resolve the issue?