Forum Discussion

Ramkishor's avatar
Ramkishor
Icon for Helper II rankHelper II
3 months ago
Solved

D365 F&O Tables Randomly Getting Unsynced from Fabric via Link to Fabric / Azure Synapse Link

Hello Anonymous , We are using Microsoft Fabric in our Production environment and have been successfully consuming Dynamics 365 Finance & Operations data through Link to Fabric and Azure Synapse Lin...
  • Murtaza_Ghafoor's avatar
    Murtaza_Ghafoor
    3 months ago

    Ramkishor 

    1-Azure Synapse Link / Fabric Link to Fabric Monitoring (First Place to Check)

    In D365 F&O:

    Go to System administration(if you have access to Power Platform admin Portal) → Setup → Azure Synapse Link (or Link to Fabric).

    Open your link profile.

    Review:

    Table status

    Failed tables

    Synchronization status

    Error messages

    Recent refresh activity

    If a table was removed due to a schema validation, the error often appears in here.
    2-D365 F&O Batch Job History

    Many synchronization activities run as batch jobs.

    Navigate to:

    System administration (if you have access to Power Platform admin Portal) → Inquiries → Batch jobs

    Review:

    Failed jobs

    Cancelled jobs

    Jobs related to Synapse/Fabric Link, Export to Data Lake, or Fabric

    You may find downstream failures even when the source synchronization appears healthy.

     

     



    If this helps, ✓ Mark as Kudos | Help Others

deborshi_nag's avatar
deborshi_nag
Icon for Super User rankSuper User
3 months ago

Hello Ramkishor 

 

F&O tables need specific indexes for Synapse Link, which can be removed during environment refresh or invalidated by schema changes.

 

To resolve this, run the "Enable Entity Indexes for Synapse Link" batch job in your Finance and Operations environment. Navigate to System Administration > Setup > Azure Synapse Link > Enable Entity Indexes. Choose the tables or entities to re-index, or select all, then run the job to recreate the indexes. This restores the indexing structure for data synchronization with Synapse. Afterward, check your Azure Synapse Link configuration in the Power Platform Admin Center to ensure the tables are syncing and the required indexes are present.