Skip to main content

Notifications

Power Apps - Microsoft Dataverse
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?

  • AhmedSalih Profile Picture
    AhmedSalih 6,678 on at
    Re: Error when importing from Excel to Dataverse

    @swebb111, Happy to help 🙂

  • smw356239 Profile Picture
    smw356239 34 on at
    Re: Error when importing from Excel to Dataverse

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

  • AhmedSalih Profile Picture
    AhmedSalih 6,678 on at
    Re: Error when importing from Excel to Dataverse

    @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
    smw356239 34 on at
    Re: Error when importing from Excel to Dataverse

    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? 

  • Verified answer
    AhmedSalih Profile Picture
    AhmedSalih 6,678 on at
    Re: Error when importing from Excel to Dataverse

    @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
    smw356239 34 on at
    Re: Error when importing from Excel to Dataverse

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

  • AhmedSalih Profile Picture
    AhmedSalih 6,678 on at
    Re: Error when importing from Excel to Dataverse

    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


     

     

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,495

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,822

Leaderboard

Featured topics