cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Teresa24486
Post Partisan
Post Partisan

Import Data from Excel to Dataverse

Hi,

I am trying to import the excel file data to dataverse, but getting the error "Import failed. Click the link below to download the error details." and gives me 25 errors out of 600+ records. I did map the fields correctly. I have lookup columns, text, choice etc on the table. Can you advise on what could have gone wrong?

6 REPLIES 6
rampprakash
Power Participant
Power Participant

Hello @Teresa24486,

 

You can easily find the errored(Failure records)

Navigate to Dataverse--> Click Gear Icon on Top--> Select Advance Settings --> Select DataManagement --> Select Import --> Open the Failed Record and Click Failure Tab and you can see the Description like below screenshot.

 

if you need further help you can share the screenshot to help the same

 

rampprakash_0-1631692892580.png

There is an Option to Download Erorr File ALONE to import it again with out disturbing the existing import

 

Please mark as Answer if it is helpful and provide Kudos


Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Hi @rampprakash,

The excel import did not go through successfully, hence I cannot find the records. Please advise.

 

Teresa24486_1-1631694110766.png

 

Downloaded excel shows the below error:

 

Teresa24486_0-1631694075293.png

 

dpoggemann
Super User
Super User

Hi @Teresa24486 ,

 

The data looks to be unreadable for these rows in your exported file.  Not sure why this is...  Did you check the source data of these records to see if you have anything that looks weird?   One thing that usually causes failures for me on imports like this is when the record's lookup can't be resolved because there are duplicates in the Dataverse.  Not saying this is the case here but usual condition I have.  

 

In the user interface for the errors, does it give a reason the record failed?  It will usually say the error in the UI.

 

Thanks,

Drew

Hi @dpoggemann

I do not have duplicates in the lookup, its a list of values, not sure why it is appearing this way on the excel sheet.

rampprakash
Power Participant
Power Participant

Hi Teresa,

 

If you are okay we can jump into a Private Chat and have a look on the data and help you the same as @dpoggemann mentioned need to have a clartity in the screenshot which you have shared to help you the same

 

Please mark as Answer if it is helpful and provide Kudos


Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Hi @dpoggemann 

It doenst give me the reason for error. The error file gives me 25 records in which one of the column data is unreadable. Can you please advise?

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,694)