Excel import from table not showing any data after completed?

(1) Share

Report

Posted on by Usernametwice

503

Hi all,

I'm simply trying to export data from one environment to another.

I export data to excel and download the Excel workbook. I then click 'import from Excel' in the other environment (same table). No errors appear and when I go to the 'My imports' section, I can see that the import 'completed' under status reason.

The problem is that I cannot see any records imported into the table. No 'errors' or 'failures' show under the My Imports section and neither do any 'successes'?

The data I am trying to import contains multi select option sets and dropdown selections. Could this be the issue?

Thank you to anyone that can help!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

AhmedSalih

6,678 Moderator on at

Like (0)

Report

Hello, @Usernametwice23, The choices columns values should not cause an issue when importing from Excel to Dataverse as long as your Dataverse table has the correct choices values created in the Choices list. Not to mention that you should get an error if that is the case. As best practice to move data from one environment to another, is to use Dataflows. If your Dataverse table schemas are identical, then create Dataflows to move the data from Environment to another. Make sure that you have Alternate Keys setup if you are moving the data between the two environments as part of an integration process or ALM.

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

Fubar 8,354 Super User 2025 Season 2 on at

Like (0)

Report

Usually when you do a data import and nothing gets created it is because it thinks it is performing an update rather than an insert.
You may need to edit the source file (can try unhiding the frist 3 columns, and clearing the do not delete checksum column), or copy the data to another file save it as .csv or XML 2003, and then import it from the Data Import section in Advanced (i.e. not the Excel import).

Was this reply helpful? Yes No