Forum Discussion

ian_'s avatar
ian_
New Member
1 year ago

Fabric Link Dataverse F&O

I use Fabric Link to connect Dataverse and F&O to Fabric from PowerApps. However, any changes I make in F&O are not reflected in Fabric. I tried referring to Copilot and GPT, but they keep suggesti...
Need Help
Show and Tell
Poojara_D12's avatar
Poojara_D12
Icon for Super User rankSuper User
1 year ago

Hi ian_ 

The issue is likely caused by the stuck "Initial Sync In Progress" state of the File Attachment and Elastic File Attachment tables. Here's how to fix it:

  1. Check Sync Logs: Go to Dataverse > System Jobs and review the logs for errors related to these tables.

  2. Force Sync Restart: Disable the Fabric Link, delete it, and recreate the connection. Ensure no pending sync jobs exist in System Jobs before relinking.

  3. Exclude Problematic Tables: If the tables are not required, exclude them by customizing the table sync configuration during relinking.

  4. Microsoft Support: If the issue persists, open a ticket with Microsoft as this could be a backend issue.

 

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Please Subscribe my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS 

  • ian_'s avatar
    ian_
    New Member
    1 year ago

    There are no log error at all. I can't exclude the table fileattachment & elasticfileattachment. I will force sync restart the link within next few days

  • ToddChitt's avatar
    ToddChitt
    Icon for Super User rankSuper User
    1 year ago

    Poojara_D12 

    Can you expound a little on your suggestions? I too have a Dataverse environment that supports Microsoft Dynamics Business Central, and I set up the "Link to Microsoft Fabric" a few days ago, but it seems to be stuck.

     

    1. Check Sync Logs: Go to Dataverse > System Jobs and review the logs for errors related to these tables. Where are you seeing this? From make.powerapps.com environment?

    2. Force Sync Restart: Disable the Fabric Link, delete it, and recreate the connection. Ensure no pending sync jobs exist in System Jobs before relinking. How do you disable the link, or Force Sync Restart? Where do I find System Jobs?

    3. Exclude Problematic Tables: If the tables are not required, exclude them by customizing the table sync configuration during relinking. My understanding is that Link to Fabric takes ALL tables and there is nothing you can do to pick and choose individual tables. 

    Thanks in advance.