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.
Comments
I agree with you, I too have to manually remove over 100 tables then add them back perfectly every time so our Datawarehouse team can do their jobs. This is easily something that could be automated or just not broken intentionally when an environment is refreshed.
Category: Dataverse