We currently have a Fabric Synapse Link setup between our Dynamics data which is in Dataverse with our Fabric workspace Lakehouse. We found an issue where the data in one of the existing columns within a table was not populated correctly. When the issue was brought up, our Dynamics team ended up creating a new field where the data should now be populated. And it is populated at the dataverse table. The synced table in Fabric received the new metadata change. However, not all the data came through for that new field. I am not seeing any errors in the SYNC status. What could be the reason for a partial update from the source? One option was to remove the table from the sync and add it back in. But this might have been one of the built in system table where I do not have the option to do so. The last resort would be to unlink Fabric connection, delete or remove all the tables from the Lakehouse and recreate the Fabric Synapse link which I was wanting to avoid. Any assistance or direction would be appreciated.
Thanks in advance,
Nimesh