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,... / Opportunities Entity i...
Customer experience | Sales, Customer Insights,...
Suggested Answer

Opportunities Entity import error

(0) ShareShare
ReportReport
Posted on by Sara Imran 20

An excel file was uploaded in Opportunities entity and all the existing records in entity just went blank like (title, account name, contact name etc.) just disappeared and a dashed line appeared in their place instead. (screenshot attached).2437.a.PNG

1) what actually went wrong here??

2) Can I recover the lost data in the future?

2) What security measures should I take to avoid data loss in the future?

I have the same question (0)
  • Temmy Wahyu Raharjo Profile Picture
    Temmy Wahyu Raharjo 2,916 on at

    Hi, how you prepare your excel in the first place? Do you export it from advanced find, then fill it again using the formatted result?

  • Suggested answer
    Pradeep Rai Profile Picture
    Pradeep Rai 5,489 Moderator on at

    Hi,

    Below are suggestions for your questions:

    1) what actually went wrong here? - This may happen because excel values are not proper or may be during the import mapping fields are ignored

    2) Can I recover the lost data in the future? - Better to take backup whenever we are importing data.

    3) What security measures should I take to avoid data loss in the future?-Better take backup of existing entity data.
    You can use below plugin of Xrmtoolbox to take backup:
    https://www.xrmtoolbox.com/plugins/ITLec.RaiseYourVoice.D365RestorePoint/

    Thanks,
    Pradeep.
    Please mark this as VERIFIED if it helps.

  • Rakesh90 Profile Picture
    Rakesh90 200 on at

    Hi Sara Imran

    If you have Auditing enabled in the entity, you can recover the lost data.

    To recover the lost data use Recycle Bin app from Xrmtoolbox.

    When bulk updating fields, make sure you delete the columns from the excel that you dont want to update (except the hidden A,B,C columns)

    If the above suggestion worked, please mark my answer as verified

  • Suggested answer
    Yoshika Suzuki Profile Picture
    Yoshika Suzuki Microsoft Employee on at

    Did the existing record get overwritten?

    Did you export the original data, modify it and import it?

    How about allowing duplicate records and importing them?

    You can restore the environment from PPAC. However, not only Opportunity, but all data in the environment will be restored.

  • Sara Imran Profile Picture
    Sara Imran 20 on at

    Yes. I export the excel file with the existing data that's already there and then add the new data in the fields and then import it again

  • Sara Imran Profile Picture
    Sara Imran 20 on at

    Yes it seems it got overwritten but like instead of names and values, the data fields are displaying these dashed lines. So the data has been replaced by these dashed lines idk how and why

    Yes. I export the excel file with the existing data that's already there and then add the new data in the fields and then import it again

    I'm selecting no for the allow duplicate records option;

    Yes looking into PPAC but I just want to ensure it doesn't happen again

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 202 Super User 2026 Season 1

#2
CU11031447-0 Profile Picture

CU11031447-0 100

#3
NeerajPawar Profile Picture

NeerajPawar 70

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans