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
