Fabric status shows Failed for an F&O table

[jtenbroek1]

We recently went live with Fabric and a premium capacity, and things appeared to be working fine for a few weeks.  All of the sudden yesterday, we noticed that one of our tables was not refreshing.  We tried to unlink the table and then resync it, however the Fabric status continues to show "Failed" for that one table and no others.  Any pointers into what to look for or how to resolve this?  

[JamesDuRivers · Accepted solution]

Hi @jtenbroek1,

We solved our problem by disconnecting and reconnecting Fabric.

[JamesDuRivers]

Same issue here on all D365FO tables.

Steps attempted > 1. Clean up all F&O tables in Datalake on Fabric

2. Remove all F&O Tables in PowerApp Synapse Link(OneLake)

3. Rebublish all tables

Result: Still Failed Status on Fabric side.

[Pankaj-Fabric]

I am facing this issue with the F&O virtual tables (mserp). The table is created for the first time, but if you uncheck the table in the Manage table (Azure Synapse Link for Dataverse) and later try to bring the same table back into Fabric, I see the Fabric status "Failed". There is no documentation explaining how to select and deselect the Dataverse tables for Fabric.

[ldakkermans]

@v-kpoloju-msft I am facing the same issue as @jtenbroek1, but for a different table. 
I am struggling to find your path to look for the diagnostics:
Microsoft Fabric > One Lake > Azure Synapse Link > Activity log / Diagnostics. 

In MS Fabric, do you mean the One Lake catalog? Because there I can not find the azure synapse link

cheers, Luc

[v-kpoloju-msft]

Hi @jtenbroek1,
Thank you for reaching out to the Microsoft fabric community forum.

After reviewing the details you provided, I have identified few workarounds that may help resolve the issue. Please follow these steps:

The root cause is likely due to a sync metadata or schema inconsistency for the inventsum table from Finance & Operations, possibly triggered by a recent schema change, permission issue, or stale artifacts in Fabric. Despite re-linking, Fabric continues to reference outdated or conflicting metadata, resulting in a persistent "Failed" status during sync.

Navigate to Microsoft Fabric > One Lake > Azure Synapse Link > Activity log / Diagnostics. Examine detailed error logs or exception messages for the inventsum table, focusing on timestamps that match the failed sync attempts. Fully remove the sync metadata before re-adding it: In Fabric, go to the workspace and delete any stale datasets or tables associated with inventsum. In the Synapse Link UI: Unlink the inventsum table. Wait 5–10 minutes to ensure cleanup. Re-link it and monitor for fresh metadata generation.

Ensure that Fabric retains: Access to the One Lake storage account. The correct permissions to the relevant F&O environment. If permissions were recently changed, this could affect only certain tables.

Compare the table schema for inventsum in F&O with what Fabric expects. Check partition settings (Year partition is shown) and try simplifying the partitioning temporarily before re-linking. In Power BI Admin Portal or Fabric Admin Settings, review: Resource consumption. Queued or failed background jobs. Dataset refresh history.

Kindly refer to the below documentation link for better understanding:
Choose finance and operations data in Azure Synapse Link for Dataverse - Power Apps | Microsoft Lear...
Azure Synapse Link for Dataverse trouble shooting guide - Power Apps | Microsoft Learn

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.

[v-kpoloju-msft]

Hi @jtenbroek1,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-kpoloju-msft]

Hi @jtenbroek1,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-kpoloju-msft]

Hi @jtenbroek1, 

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[GoGo94]

 @v-kpoloju-msft I too am facing the same issue with another different table, but for me it is not clear what you mean with "In Fabric, go to the workspace and delete any stale datasets or tables associated with inventsum". 
The table doesnt exist anymore in the lakehouse.

In the Synapse Link UI  I have tried unlinking the table, waiting up to 20 minutes and relinking it but immediately it shows Fabric status "Failed".