web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : hhk1zTlBhBePAEy8jSMMJ3
Power Apps - Microsoft Dataverse
Unanswered

Migrate data between environments

Like (0) ShareShare
ReportReport
Posted on 23 Sep 2021 20:38:17 by

I got a DEV environment that I'm ready to push into PROD.

Everything is packaged in a solution but there are some tables that contain reference data that should be moved to PROD.

I was told that Dataflows were the way to go but I'm not sure how to configure it or if there might be a better way to move the data.

  • THowkins96 Profile Picture
    88 on 16 Jan 2023 at 13:29:58
    Re: Migrate data between environments

    Hi @dpoggemann ,

     

    I am having the exact same issue here with the error of more than one sheet. There is only one tab, no hidden tabs. It is recognising "Table1" as another sheet, which is causing the error.

     

    I then tried converting table to range and it still recognises "Table1" as a second sheet.

     

    Any ideas?

    Thanks,

    Tom

  • Community Power Platform Member Profile Picture
    on 06 Oct 2021 at 13:21:13
    Re: Migrate data between environments

    Thanks for the input! Unfortunately, I was not able to get it working.

    I ended up using the XRM toolbox with the Data Transporter plugin and it works like a charm.

  • Drew Poggemann Profile Picture
    9,278 Most Valuable Professional on 25 Sep 2021 at 10:57:57
    Re: Migrate data between environments

    Hi @Anonymous ,

    Columns A,B,C are hidden because they are key information that is utilized if you export and make updates to data and re-import into same environment.  When you export from Dev these will exist as well and will be populated but do not put them into the production file.

     

    I have done thousands of records with this approach.   Usually if I have a large number of records I break into multiple files though...

     

    Thanks,

     

    Drew

  • Drew Poggemann Profile Picture
    9,278 Most Valuable Professional on 25 Sep 2021 at 10:57:49
    Re: Migrate data between environments

    Hi @Anonymous ,

    Columns A,B,C are hidden because they are key information that is utilized if you export and make updates to data and re-import into same environment.  When you export from Dev these will exist as well and will be populated but do not put them into the production file.

     

    I have done thousands of records with this approach.   Usually if I have a large number of records I break into multiple files though...

     

    Thanks,

     

    Drew

  • Community Power Platform Member Profile Picture
    on 25 Sep 2021 at 00:00:17
    Re: Migrate data between environments

    #4 - Fair enough, will give it a try!

     

    #5 - There was only 1 blank sheet (with columns A, B and C missing). Will try again with step 4 completed, unless you have an idea about something that could've triggered this error.

     

    Also, is there a maximum amount of records that can be transferred for this method? Are there certain limitation that should be known?

  • Drew Poggemann Profile Picture
    9,278 Most Valuable Professional on 24 Sep 2021 at 23:55:02
    Re: Migrate data between environments

    Hi @Anonymous ,

     

    #4 - I usually go into a simple Model App to do this and have a View that contains all the fields I need to export.  From the View you will have the ability to "Export to Excel" from the View menu.  I then manually copy / paste the information into the import template.  

     

    #5 You need to make sure this is a single worksheet file in the Excel template otherwise it will not import.  Can't have a Sheet1, Sheet2...

     

    Thanks,

     

    Drew

  • Community Power Platform Member Profile Picture
    on 24 Sep 2021 at 20:39:27
    Re: Migrate data between environments

    #1 to #3 are fine.

    For #4, where would I go to export the data and how do you add it into the template?

    As for #5, I'm not sure I'm in the right place because I get this error message when I upload the template in the mapping page: 

    The file could not be uploaded for Account: [UnknownError] Excel file with more than one sheet is currently not supported.
     
    Any ideas?
  • Drew Poggemann Profile Picture
    9,278 Most Valuable Professional on 24 Sep 2021 at 02:37:12
    Re: Migrate data between environments

    Hi @Anonymous,

     

    Most every time I have data from a dev environment that I need to migrate to production I usually do the following:

    1.  Go to https://admin.powerplatform.microsoft.com and click on "Environments"

    2.  In the Production environment, click on Settings

    3.  Expand the Templates and you will see data import templates

    Screen Shot 2021-09-23 at 9.33.14 PM.png

    4.  Export the data from your development environment and populate into the import template from the development data.  Note, do not populate the columns A-C since this is keys for your development rows.

    5.  In the Views page for the entity, import the data to the production environment through the Import from Excel

     

    Overall I have migrated a large number of tables quickly with this approach and it is simple.

     

    Hopefully this helps.  Please accept if answers your question or Like if helps in any way.

     

    Thanks,


    Drew

     

    to another environment I usually just utilize Excel the data template for the table / entity from the production environment and then export the data from the dev environment and put this into the 

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Featured topics