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?
Ahmed, the DataFlows worked for me. Thanks for your help.
@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
|
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?
@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
|
@AhmedSalih I'm using the import from excel; this is a one time import.
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
|