Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Answered

Cannot import data

(0) ShareShare
ReportReport
Posted on by 254

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:
  • Verified answer
    Hilda Steyn Profile Picture
    Hilda Steyn 254 on at
    Re: Cannot import data

    This issue is due to my environment being in South Africa. 

    I logged a ticket with MS and they are investigating. 

  • Drew Poggemann Profile Picture
    Drew Poggemann 9,273 on at
    Re: Cannot import data

    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:

    Screenshot 2023-03-21 at 7.45.24 PM.png

    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!

  • AhmedSalih Profile Picture
    AhmedSalih 6,678 on at
    Re: Cannot import data

    @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

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard

Featured topics