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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Engage with the Community / Dataverse - Data full ...
Engage with the Community
Suggested Answer

Dataverse - Data full restore only

(0) ShareShare
ReportReport
Posted on by Woody

Currently our Dataverse environment is linked to D365 F&O for dual write use when the F&O team restores data from Production to UAT it brakes the link cause F&O UAT data now matches Production F&O data but Dataverse still has UAT data.

I would like to know if anybody knows of a way to do a Data only restore from Prod Dataverse to UAT Dataverse with out the risk of loosing development on Dataverse UAT environment.

I have the same question (0)
  • Suggested answer
    11manish Profile Picture
    11manish 457 on at
    Yes—you can refresh UAT data without losing development, but not by using a full Dataverse restore. You need a data-only refresh strategy, not environment restore.
     
    Why your issue happens
    With Dual Write between Microsoft Dataverse and Dynamics 365 Finance and Operations:
    • F&O UAT is refreshed from Prod 
    • Dataverse UAT still has old UAT data
    Result:
    • Data mismatch → Dual Write breaks
    Recommended approaches (safe options)
    Option 1: Configuration Migration Tool (BEST)
    Use:
    • Configuration Migration Tool
    What it does:
    • Moves data only
    Keeps:
    • Schema
    • Customizations
    Steps:
    • Export data from Prod Dataverse
    • Import into UAT Dataverse
    • Select only required entities
    Safe for development environments
     
    Option 2: Dataflows / Power Query
    Use:
    • Dataflows in Dataverse
    Benefits:
    • Incremental load
    • Controlled refresh
    Good for ongoing sync scenarios
     
    Option 3: Power Automate / ETL sync
    Use:
    • Microsoft Power Automate
    Pattern:
    • Read from Prod
    • Write to UAT
    Flexible but slower for large datasets

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the February Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Engage with the Community

#1
ManoVerse Profile Picture

ManoVerse 10

#1
wolenberg_ Profile Picture

wolenberg_ 10 Super User 2026 Season 1

#3
J-D-M Profile Picture

J-D-M 5

Last 30 days Overall leaderboard

Featured topics

Welcome to the Community Check In & Claim your PPCC Digital Swag
Welcome to the Engage with the Community forum

Product updates

Microsoft Power Platform Community release plans