web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Error when importing f...
Power Apps
Answered

Error when importing from Excel to Dataverse

(0) ShareShare
ReportReport
Posted on by 34

All,

 

I'm getting this error:

Import failed: There was an error getting the project execution status. Executing

 

Trying to import an Excel doc to dataverse table. Matched up the columns/mapped them properly. I didn't see anything in the dataflows to indicate an error. The error itself isn't very helpful. Any thoughts on how I can track down the root cause for this issue?

I have the same question (0)
  • AhmedSalih Profile Picture
    6,678 Moderator on at

    Hello, @swebb111 are you using Import from Excel feature or you are using Dataflows?

     

     

    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


     

     

  • smw356239 Profile Picture
    34 on at

    @AhmedSalih I'm using the import from excel; this is a one time import.

  • Verified answer
    AhmedSalih Profile Picture
    6,678 Moderator on at

    @swebb111, as best practice, I like to use DataFlows for Excel-to-Dataverse migration. It always work for me. Create the Dataverse tables first and then use DataFlows to load the Data from Excel to the existing Dataverse tables. I have this full tutorial to help you achieve this: https://powerplatformplace.com/f/excel-to-dataverse-migration---part-1

     

     

    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


     

     

  • smw356239 Profile Picture
    34 on at

    I'm getting to the point now where I'm getting a POST error on the data I'm trying to import. I don't know if I should start a new thread or continue it on this one. 

    I'm trying to append to an already existing data table. Will your suggestion of using data flow work for that? 

  • AhmedSalih Profile Picture
    6,678 Moderator on at

    @swebb111 You can append if you create an Alternate Key in the Dataverse table. The Alternate Key can be one or morel columns whatever will produce a unique value for each records. Once you create the Alternate Key, your DataFlows will append to the existing data records in the Dataverse table.

     

     

    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


     

     

  • smw356239 Profile Picture
    34 on at

    Ahmed, the DataFlows worked for me. Thanks for your help.

  • AhmedSalih Profile Picture
    6,678 Moderator on at

    @swebb111, Happy to help 🙂

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 386 Most Valuable Professional

#2
Kalathiya Profile Picture

Kalathiya 361

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 339 Super User 2025 Season 2

Last 30 days Overall leaderboard