Showing results for 
Search instead for 
Did you mean: 
Advocate III
Advocate III

Data Snapshot Dataverse Table

Hi lovely community, 


currently I'm wondering how to copy about 55K Records incl. 120 columns (about 20 lookup columns) from one table 1:1 to another table? This is just one time per year to have kind of "Snpashot". 

Just archiving or exporting records to file is not an option. We need it as the same table.


I already have cloned the table via XRMTool. Have set up Power Automate (connected with Power Apps) to trigger copying of one year.

Unfortunately there's the following limit (aready have splitted requests in 12 months):



Do you know a faster and more stable way to copy records from one table to another table in dataverse?

Unfortunately I can't use Dataflows cause there are some lookup columns and their tables behind without data integration key (and it wouldn't make sense here to create one).





Super User
Super User

Hello @P3Sven 


Please try creating Dataflow to sync between Environments.


Steps to Follow:


1. Navigate to 

2. Open DESTINATION ENVIRONMENT and Click Dataflow --> Click New Dataflow

3. Search for Dataverse

4. Enter the Source URL (where SOURCE data available) --> Provide Credentials

5. Select the  Source Table

6. Click Transform Data/Next --> Select the DESTINATION TABLE/ CREATE NEW TABLE and Click Next and Select the Frequency of Sync

7. Click OK/ PUBLISH.


That's it 🙂


Please mark as Answer if it is helpful and provide Kudos

Subscribe :
Blog :

Hi @rampprakash ,


thanks for your reply, but like I've mentioned, with dataflows I can't create lookups without data integration keys of related table (unfortunately I've some).

If Dataflow would allow me to create lookup connection via dataverse unique id, it would work, but its just working via integration key to create lookups..




Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (3,863)