Current Behaviour: Once the Azure Synapse Link for Dataverse is setup, all the tables with parent child relationships are synced with the correct value of Parent Name column in Child Table. However, when the parent record primary name field is updated in Dataverse, there is no trigger in Dataverse for child table, hence the parent table gets updated in Azure Data Lake and child table doesn't get cascaded with the parent's primary name field value. Any new child record created in Dataverse then has the new parent's primary name value. This leads to a discrepancy in the parent's primary name value in the parent table with respect to an old value in Child table.

ISSUE: Now it you have a reporting based on parent's name value from child table without knowing that the value won't be update, it leads to all the reports not functioning properly.

ASK: Please help with finding a way to have this data sync appropriately based on the changes in parent name. Alternatively, please help develop a tool which should update all the child tables with the latest parent's primary field name value