Duplicate value found: BaseDatasetId duplicates value on record with id [ Field Name ] - Solution

🚨 The Error

While working with Salesforce CRM Analytics (formerly Einstein Analytics), you might encounter this error:

duplicate value found: BaseDatasetId duplicates value on record with id: 0Iv8Z0000013bgwSAA

This can happen when:

• Creating or editing a recipe using existing datasets.
• Adding new fields to a dataflow.
• Running a sync from SFDC Local in Data Manager.
• Rebuilding datasets that already exist in the system.

🧠 What It Means

Every dataset in CRM Analytics is tied to a unique BaseDatasetId. This error indicates that Salesforce is trying to re-register a dataset using an ID that already exists — usually due to:

• Incomplete metadata cleanup from previous operations
• Failed syncs leaving behind stale references
• Duplicated or corrupted dataset registrations

🛠️ Step-by-Step Fix

1. Identify the Dataset

• Note the record ID from the error (e.g., 0Iv8Z0000013bgwSAA).
• Use Monitor > Data Manager to trace where this dataset is used.

2. Modify the Recipe or Flow

• Remove the dataset temporarily from your recipe or dataflow.
• Save changes to force a metadata update.

3. Fix Sync Conflicts

• Go to Data Manager > Connect > SFDC Local.
• Deselect the affected object.
• Run a sync (this clears old metadata).
• Re-select the object and run sync again.

4. Rebuild if Needed

• If the problem persists, delete the dataset and rebuild it.
• Create a new recipe or dataflow with clean references.

✅ Summary

This error is caused by Salesforce CRM Analytics attempting to reuse a BaseDatasetId that's already taken. The fix is often a matter of removing stale references, syncing freshly, and rebuilding with updated metadata.