You’re offline. This is a read only version of the page.
353
Hi,
I need some help with importing data from Dataverse tables into another solution. I've imported the solution to another environment, so the tables (empty) were also created as part of the solution and everything went well with that. Now, I would like to import data as well so I don't have to input everything all over again.
I am doing the following:
1. Export data from Dataverse tables as .csv file
2. Import data as .csv to a new solution
3. I select Load data into existing table and pick that table from the list
4. I select Key column and map other columns
5. Finally I publish it
6. I repeat the process for all other tables
However, lookup columns inside several tables are not being populated. All other data is there, except values in lookup columns. I was careful during the import to first import parent tables data and then data for the tables that have lookup columns.
When the data was previewed, I double-checked and those lookup column values were there with the correct ID of the primary column of the parent table. Pls see below that the lookup column contains data and that IDs match with the primary column.
Child table, lookup column:
Parent table, primary column:
Anyhow, once the data is imported, that particular column is empty:
Can someone point me to what am I doing wrong here?
Thank you.
Best
Good to know that your issue is resolved now. You can always use VM/AVDs to use tool not supported on Mac.
csv import is always tricky and tedious job to do especially when you have data to be imported for related tables.
Good to know that your issue is resolved now. You can always use VM/AVDs to use tool not supported on Mac.
csv import is always tricky and tedious job to do especially when you have data to be imported for related tables.
Did you try using Data Migration Utility ? That is the best way to migrate data between environments.
https://learn.microsoft.com/en-us/power-apps/developer/data-platform/dataverse-odata-dataflows-migration
I've tried using OData in dataflows instead of csv files, following steps from Microsoft docs Migrate data between Microsoft Dataverse environments using the dataflows OData connector - Power Apps | Microsoft Learn
Though I did exactly as said in the above link, I am getting an error for the child table after publishing dataflow. Here is the error I get:
Share
Report
All responses (
Answers (
{"message":"A record with the specified key values does not exist in XXX_initiative entity","cdsErrorCode":"0x80060891","HelpLink":"http://go.microsoft.com/fwlink/?LinkID=398563&error=Microsoft.Crm.CrmException%3a80060891&client=platform","InnerErrorMessage":"A record with the specified key values does not exist in XXX_initiative entity","cdsRequestId":"92fad875-18bc-417b-8f32-727d534fff49","cdsRequestUtcTime":"6/30/2023 12:08:58 PM"}
This is becoming really frustrating as I can't see what I am doing wrong here.
#1
stampcoin
17
#2
ankit_singhal
11
Super User 2025 Season 1
#3
mmbr1606
9
Super User 2025 Season 1
