Add a record and data publish through excel add in / in d365fo then its showing error : Original data contains duplicate entries

(0) Share

Report

Posted on by Awais Qurni

Data export in excel through data entity ,its export all the from table in excel and when I put a record and publish the data through data connector window and its showing a error: Original data contains duplicate entries.

I try after exporting the data in excel delete the existing record and then i put a record this time data publish successfully. But its not a solution . I want when export data in excel existing record not exist in excel file or in the presence of existing record my data will do successfully with no error.

How it is possible , Please give me suggestions thanks.

All responses (4)

Answers (0)

Suggested answer

Komi Siabi 12,748 Most Valuable Professional on at

Like (0)

Report

RE: Add a record and data publish through excel add in / in d365fo then its showing error : Original data contains duplicate entries

Hi Awais Qurni ,

Kindly mark answer(s) verified, to archive this post.
Awais Qurni 56 on at

Like (1)

Report

RE: Add a record and data publish through excel add in / in d365fo then its showing error : Original data contains duplicate entries

Yes
Suggested answer

Komi Siabi 12,748 Most Valuable Professional on at

Like (1)

Report

RE: Add a record and data publish through excel add in / in d365fo then its showing error : Original data contains duplicate entries

Hi @Muhammad Awais Qurni,

Truly, the last two records are duplicates. The error simply means, there is a table on the entity which does not allow duplicate records.

Please double check before publishing.
Suggested answer

BillurSamdancioglu 16,176 Most Valuable Professional on at

Like (2)

Report

RE: Add a record and data publish through excel add in / in d365fo then its showing error : Original data contains duplicate entries

Hi,

How do you try to delete the data?

First delete the data and publish. Then try to upload new please