web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

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

(0) ShareShare
ReportReport
Posted on by 56

 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.

pastedimage1661795671304v2.png

pastedimage1661795703255v3.png

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.

I have the same question (0)
  • Suggested answer
    BillurSamdancioglu Profile Picture
    19,703 Most Valuable Professional on at

    Hi,

    How do you try to delete the data?

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

  • Suggested answer
    Komi Siabi Profile Picture
    13,093 Most Valuable Professional on at

    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.

  • Awais Qurni Profile Picture
    56 on at

    Yes

  • Suggested answer
    Komi Siabi Profile Picture
    13,093 Most Valuable Professional on at

    Hi Awais Qurni ,

    Kindly mark answer(s) verified, to archive this post.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 660 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 549 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 307 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans