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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Issue to enable row ve...
Finance | Project Operations, Human Resources, ...
Unanswered

Issue to enable row version change tracking for custom data entity for Azure Synapses Link

(1) ShareShare
ReportReport
Posted on by Dhruv R Thakar 214
Requirement: For one of our client, it is required to expose custom data entity (Data Entity - A) to Azure Synapses Link.

Approach: Because of the MS validation rules, we cannot enable the change tracking for the Data entity - A from the back end (Visual Studio). Therefore, we decided to create a new table (Table - B) that pulls the records periodically from the Data entity - A depending on the business needs. We will expose the Table - B to Azure Synapses Link for further usage.
 
 
D365 F&O Scheduler: This will pull all the data periodically from the data entity (Data entity - A), delete all the historical records from the Table - B and insert those selected sets of records into Table - B that we will expose to Azure Synapses Link.
 
 
Question: I am just looking for some best suggestions/ideas to achieve this requirement.
I have the same question (0)
  • Anton Venter Profile Picture
    Anton Venter 20,345 Super User 2025 Season 2 on at
    I would not recommend this approach because you are creating a point of failure and you are creating extra overhead for F&O, especially if there is a lot of data. If you really must do this, then update the data in the cache table, do not delete everything and populate it from scratch.
     
    Your data entity consists of data sources (tables). Why not use those tables directly in Dataverse / Synapse Link for Dataverse? What is your data entity doing extra? Is there a lot of business logic etc that can't be replicated?
     
    By the way, which MS validation rule prevents enabling change tracking on your data entity?
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 300,917 Super User 2025 Season 2 on at
    Hi Dhruv,

    Is it possible to use Table A in the Synapse link instead of the related data entity? Can you tell more about your customization? What is Table A about and what are the specifics of the data entity for Table A?

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 664 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 522 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 303 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans