web
You’re offline. This is a read only version of the page.
close

Léopold GRANGER Data engineer

Léopold GRANGER

Joined: 6/11/2024

  • Script table desync and resync via the Link to Microsoft Fabric

    about a year ago – Power Platform Governance and Administration – New 

    We link D365 F&O tables to Fabric via the link to Microsoft Fabric, with microsoft onelake. When issues arise on the D365 F&O side and the link is broken, all tables will go out of sync. To fix this, we need to:

    • remove all D365 tables manually (via Manage tables)
    • wait for the tables to be deleted on the Fabric side (can take multiple hours)
    • refresh Fabric tables
    • add all d365 tables manually (via Manage tables)
    • wait for the tables to be get out of initial sync
    • refresh Fabric tables

    This process is painful for us, we would like to be able to script those activities, so this process can happen automatically in case of table errors all across the board.