web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Add a record and data...
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 Awais Qurni 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
    Komi Siabi Profile Picture
    Komi Siabi 13,019 Most Valuable Professional on at
    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 Profile Picture
    Awais Qurni 56 on at
    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 Profile Picture
    Komi Siabi 13,019 Most Valuable Professional on at
    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 Profile Picture
    BillurSamdancioglu 18,192 Most Valuable Professional on at
    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

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

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

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 665 User Group Leader

#2
Martin Dráb Profile Picture

Martin Dráb 595 Most Valuable Professional

#3
Yng Lih Profile Picture

Yng Lih 558

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans