Cannot import data

(0) Share

Report

Posted on by Hilda Steyn

289

Am I the only one battling to import data?

If I click Import > Import data from Excel, I immediately get this error message: The file could not be uploaded for [table name]: failed to upload. This happens for workbook and csv.

If I click Import > Import Data, nothing happens.

These are not new tables, I have been using them for a while, with the same import template, without problem. No changes have been made since the previous import.

Any idea on what to do?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

AhmedSalih

6,680 Moderator on at

Like (0)

Report

Copy link

Link copied!

@hildasteyn, As a best practice and it seems to always work for me without any issues, use Dataflows to import Excel data into Dataverse tables. That is why I created this full tutorial : https://powerplatformplace.com/f/excel-to-dataverse-migration---part-1?blogcategory=Dataverse

If my reply helped you, please give a 👍 , & if it solved your issue, please give a 👍 & 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

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos

New Project.png

Was this reply helpful? Yes No

Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @hildasteyn ,

I have imported from Excel "MANY" times in past projects and I 99% of the time utilize the data import templates for the entity (dataverse table) and export this template from Dataverse. If you go into admin.powerplatform.com and get into the templates you will see templates for the table:

You will be able to select the data import templates and select your table and then import the data. I have done this MANY times across multiple projects to import data and of course you need to manage the relationships as you import data but it works very well. There are plenty of other options but this has worked for me personally!

Was this reply helpful? Yes No
Verified answer

Hilda Steyn 289 on at

Like (0)

Report
Copy link

Link copied!

This issue is due to my environment being in South Africa.
I logged a ticket with MS and they are investigating.

1 people found this reply helpful.

Was this reply helpful? Yes No