Reply
Hrishi_K_M_2000
Frequent Visitor

Dynamics 365 F&O to Fabric Integration(change tracking disabled)

Hi Community,

 

We have a requirement where we need to bring Dynamics F&O tables/entities to Microsoft Fabric (to which the change tracking is not enabled). I am trying to figure out a solution as it is on high priority.

Please let me know if there is any workarounds like Data pipelines/ Dataflows (Using OData and Dataverse but I am unable to see non CDC tables). 

Additionally, I would like to understand if the tables or entities need to have change tracking enabled(or ay specific conditions) in D365 F&O in order for the tables/entities to be reflected in PowerApps/Dataverse.(Apologies as I am new to Dynamics/dataverse).

Thanks in advance!

2 ACCEPTED SOLUTIONS
FabianSchut
Super User
Super User

Hi @Hrishi_K_M_2000, according to documentation, track changes need to be enabled indeed: https://learn.microsoft.com/en-us/power-apps/maker/data-platform/create-edit-entities-portal?tabs=ex...

Track changesEnables data synchronization in a performant way by detecting what data has changed since the data was initially extracted or last synchronized. This option must be enabled for certain features such as Azure Synapse Link for Dataverse

View solution in original post

Hrishi_K_M_2000
Frequent Visitor

Hi Community,

 

As per the latest communications with support, it is confirmed that non-cdc tables cannot be brought as part of the best practices. The alternate option is
1. Enable change tracking as @FabianSchut mentioned, if the option is not available then either Microsoft needs to enable in the backend or
2. Create a custom entity and enable change tracking.


Thanks and happy learning!

View solution in original post

3 REPLIES 3
Hrishi_K_M_2000
Frequent Visitor

Hi Community,

 

As per the latest communications with support, it is confirmed that non-cdc tables cannot be brought as part of the best practices. The alternate option is
1. Enable change tracking as @FabianSchut mentioned, if the option is not available then either Microsoft needs to enable in the backend or
2. Create a custom entity and enable change tracking.


Thanks and happy learning!

Hrishi_K_M_2000
Frequent Visitor

Hi @FabianSchut ,

 

Thanks for the response.

However, I am assuming when we connect using OData in Data Factory Pipelines/Dataflows Gen2, we don't require Azure Synapse Link for Dataverse.

 

Please let me know if there are any work arounds to achieve non-cdc tables to Fabric. Is it possible to achieve this? as i don't find any documentation specifically mentioned on Data factory related pre-requisites.

Thanks again!

FabianSchut
Super User
Super User

Hi @Hrishi_K_M_2000, according to documentation, track changes need to be enabled indeed: https://learn.microsoft.com/en-us/power-apps/maker/data-platform/create-edit-entities-portal?tabs=ex...

Track changesEnables data synchronization in a performant way by detecting what data has changed since the data was initially extracted or last synchronized. This option must be enabled for certain features such as Azure Synapse Link for Dataverse
avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebFBC_Carousel

Fabric Monthly Update - February 2025

Check out the February 2025 Fabric update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)