D365 linked to Fabric - how to deselect table stucked in Initial Sync state

[andrea_barbieri]

Hi everyone!
We have an issue with deleting a table from the Finance module in Azure Synapse Link connected to Fabric.
We have connected a production environment to Fabric and have "Microsoft One Lake" on Azure Synapse Link.
We have selected some tables from "D365 Finance & Operations" in Table Manager, but some of these tables have not been created and are stuck in "Initial Sync" state for weeks.

These tables appear as errors in Lakehouse in the "Table" section in an "Unidentified" folder.
If we try to delete the tables from Lakehouse, but they remain selected in PowerApps. It is impossible to deselect them from the user interface.

We tried with Micorosft support to find a solution but the only thing we noticed was that the D365 version is not updated to the latest cumulative update available.
We have no evidence that there is a fix for this issue in the CU and the customer is not ready to start installing the CU update.
The detach functionality deletes all connections and the entire DataLake.
Do you have any idea how to "force" unlinking only for some tables?

Thanks in advance
Andrew

[Expiscornovus]

Hi @andrea_barbieri,

Haven't been able to test this myself, but the documentation suggests that you should be able to manage individual tables from the Azure Synapse Link area. Or is that the thing which you have already tried?

On the Power Apps maker portal Azure Synapse Link area, select Manage tables on the command bar to add or remove one or more linked tables.

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/azure-synapse-link-data-lake#manage...

Hopefully this helps a bit?