25 Jun’17

D365 SalesA Duplicate Lookup Reference


Best way to load data into CRM is excel/CSV.  But some time it happens that few records may not be imported into CRM.

One of the error more frequently occurs is “a duplicate lookup reference was found”.


If you are importing data using CSV, you will find that this is simplest way of importing data into the CRM. But there are chances that while importing data you may receive error.

One of them is “a duplicate lookup reference was found” looking at the error it says that you have more than 1 records with the same name while setting the look up.

But if you will try to look for the duplicate record you would not be able to find record.

As you can see in the below screen shot.

It has two fields with the same display name, so if you will try to import the records in the CRM.  You will encounter the listed error. To resolve reported error, you need make sure that you have unique display name.

Hope this blog helps you to import the records while importing the records.

Written by

Subhash Mahato

Technical Consultant

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • Reading more then 10K records in D3FOE OData API

    11 July’ 2018

    Introduction: We all know Dynamics 365 Finance and Operations has limitation of 10K records to be fetched at a time usi...

    Read more
  • Paging in D365 Customer Engagement v9.0

    10 July’ 2018

    Introduction: The Xrm.retrieveMultipleRecords method is used to retrieve a collection of records in Dynamics 365 Custom...

    Read more
  • Set up Dynamics 365 connection in Microsoft Social Engagement

    10 July’ 2018

    Introduction: This blog explains how to Set up Dynamics 365 connection in Microsoft Social Engagement. Steps to be follo...

    Read more
  • Voice of the Customer failed to install

    10 July’ 2018

    Introduction: Many people face issues in installing Voice of Customer solution on v9 environment and trying repeatedly ...

    Read more
  • Scribe Insight AX as a Web Service Find Block issue

    10 July’ 2018

    Introduction: If we need to look up for any value from AX then we do it by using a Find Block in Scribe Insight Eg: Basi...

    Read more