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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Bulk import error
Customer experience | Sales, Customer Insights,...
Suggested Answer

Bulk import error

(0) ShareShare
ReportReport
Posted on by Karthik Dayala 680

Hello,

   we have 1700 records to import for our custom entity in our production. I have created a data import file and mapped all the data correctly but failing while importing with error 'lookup can not be resolved'.

The lookup is referencing to a virtual entity.

The import works fine if i do import 20 records at a time but fails for anymore records with the same error.

i'm having to divide these and import 20 at a time.

Anyone else having the same issue? Any suggestions?

I have the same question (0)
  • Suggested answer
    Mohamed Sanuj Basheer Profile Picture
    Mohamed Sanuj Basheer 540 on at

    Hello Partner,

    'Lookup could not be resolved' usually happens when you are importing child records associated with a parent record, and the parent record doesn't exist or there are two parent records with the same value in the primary field. For example, if you import a contact with the Parent Customer value of 'Acme Inc' then you'll get this error if there is no Acme Inc or more than one.

    Can you check  your import file and ensure there are no extra commas or other characters. Extra commas will cause errors.  You can open your file in Excel and do a Find to see if there are any extra commas.  Since some of the records are importing, I suspect some data anomaly like an extra comma, a special character or some other data point that is causing an issue.

    Regards,

    Mohamed Sanuj Basheer

  • csrinjoy Profile Picture
    csrinjoy 2 on at
    I have seen this issue as well. However I do not think the sheet has any extra commas, since in the second attempt using same exact sheet I saw it went through. Most of the times I did it in batches like 30% 30 % and the rest. Any idea on how to fix it ? If its a configuration or a bug on microsofts end.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
ManoVerse Profile Picture

ManoVerse 168 Super User 2026 Season 1

#2
NeerajPawar Profile Picture

NeerajPawar 65

#3
Jimmy Passeti Profile Picture

Jimmy Passeti 51 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans