Migrating Dataverse tables from an environment to another

(0) Share

Report

Posted on by NM-19121041-0

Hello,

I'm trying to migrate both tables and data from a Dataverse environment to another. I have succeed to migrate the tables via a solution: however, when trying to import the data via the "Dataverse" connector, everything gets imported but the data present in which the tables are related.

In order to do so, i'm going to Tables > Import > Import data > Dataverse (selecting "Include relation columns: Yes"), I fill all the connection details, leave the Power Query as given and then selecting "Import in an existing table" and manually indicating which column in the previous table correspond to the column in the new table (even though the colum names and data types are actually the same, since it has been exported and imported as-is).

Does anyone have any insight about this? Thank you!

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

MichaelFP 1,845 Super User 2025 Season 2 on at

Like (1)

Report

Migrating Dataverse tables from an environment to another

For that i would recommend to use Configuration Migration Tool by installing the Power Plataform CLI Microsoft Power Platform CLI - Power Platform | Microsoft Learn

after you installed you can type in cmd

pac tool cmt

you will be able to select the tables that you want to export, exporta data and import to you target destination. And it handle relationships and you can force to turn off plugins and process to avoid unwanted process to be triggered.

If my answer helped you, please give me a thumbs up (👍). If solve your question please mark as answer ✔️. This is help the community.

Was this reply helpful? Yes No