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 : re/KAv0Jv252XlN6j0e5HE
Power Apps - Microsoft Dataverse
Answered

Reporting Replica or Keeping Entities in Sync

Like (0) ShareShare
ReportReport
Posted on 21 Aug 2019 20:07:04 by

Hello everyone,

 

I am trying to figure out how I can keep entities in sync between different environments.  One use of this would be that my test environement has the same data as my prod environment to make for better testing.  The other use would be to create a reporting replica so that my reports don't pull off of production data.  I haven't seen any way to do this so far.

 

I looked at data integration projects, but those all seem to be for data external to CDS coming in.

  • Community Power Platform Member Profile Picture
    on 13 Jan 2021 at 14:51:23
    Re: Reporting Replica or Keeping Entities in Sync

    Old topic but this was a question I had and I found the answer here: -

     

    Migrate data between Microsoft Dataverse environments using the dataflows OData connector - Power Apps | Microsoft Docs

  • Community Power Platform Member Profile Picture
    on 23 Aug 2019 at 13:35:26
    Re: Reporting Replica or Keeping Entities in Sync

    Thanks for the response.  They could be two different topics, but for me they would be the same.  Our intention is to create a reporting replica in CDS.  I see that you have reccomended an external tool to keep the CDS environments in sync.  Does that mean that there isn't some sort of internal way of handling this?  

     

    The data export service may be a good way to go.  Do you know if that handles custom entities as well?  We have both Dynamics 365 data and custom entities that drive canvas apps.

  • David Jennaway Profile Picture
    716 on 22 Aug 2019 at 11:07:35
    Re: Reporting Replica or Keeping Entities in Sync

    I think you're asking about 2 different topics: synching data between CDS environments, and creating a replica for reporting (which may or may not be in CDS).

    For synching data between CDS environments, I'd normally use a tool to do scheduled or ondemand updates, e.g. SSIS with the KingswaySoft component

    For a reporting replica, you could use the Data Export Service to sync data to a SQL database in Azure, which has the advantage of giving you direct SQL access for reporting

  • Verified answer
    v-siky-msft Profile Picture
    on 22 Aug 2019 at 07:55:35
    Re: Reporting Replica or Keeping Entities in Sync

    Hi @Anonymous ,

     

    Do you want to copy entity from production entity to test entity and keep data in sync with each other?

    Though in PowerApps, I think it is not supported at this stage to keep Entities in Sync between environments.

    However, via Flow, you may can realize that, although it's a little bit complicated.

     

    In Flow, it is unable to synchronize directly between entities from two different environment.

    But we can use SQL to transfer.

    1. Create the first flow to transfer entity to SQL in environment A.
    2. Create the second flow to sync SQL to CDS entity in environment B

    For more help, maybe you can post on Microsoft Flow Community or refer to these similar thread:

    Sync SQL table into CDS

    How-to copy attachments from the CDS to SharePoint Online

     

    Best regards,
    Sik

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

Loading complete