Welcome to the Alteryx Knowledge Base

Dataverse output error: Unique Identifier column not found
user

Created/Edited - 7/3/2025 by Karen Martinez | Alteryx

Description

While using Alteryx to perform an upsert operation on a Dataverse table, the system failed to recognise the designated primary key column.

Issue

Screenshot 2025-07-03 093303.jpg

Environment

 

Dataverse Tool version: 1.2.1 and 1.2.2

Cause

The column had duplicate values, which violated the uniqueness requirement for a primary key. The duplicate values were due to repeated test inserts. The Dataverse table expected a truly unique identifier for upsert operations.




Resolution
  1. Delete duplicate records from the table to ensure the primary key column has unique values.
  2. Recreate the unique identifier column within Alteryx and then use it
  3. Run the upsert operation, which updates existing records without inserting duplicates.



Was this article helpful?