Forum Discussion
Unable to Delete Warehouse
I was following along with a Lab: Explore data warehousing in Microsoft Fabric (Lab 06). I started the optional part involving a Semantic model but cancelled when I couldn't seem to select "My workspace" which is where I was working. However, I now cannot delete the warehouse within the workspace.
Error: This warehouse can't be deleted because there are warehouses that were cloned from it. Select View item lineage to see them.
I'm new to Fabric and so tried to use Copilot to solve the issue. Ultimately, it has suggested I post here: "From what you've described, it sounds like an orphaned transient clone reference left behind by the optional semantic model exercise, rather than a real warehouse you can delete yourself. The Fabric team or support would need to clear the metadata."
My workspace contains no other items. System storage is empty. Warehouse has been emptied. sys.databases returns only master and TempWarehouse.
This issue seems to have resolved itself overnight. I am now able to delete TempWarehouse.
4 Replies
Additional screenshot I forgot to post:
This issue seems to have resolved itself overnight. I am now able to delete TempWarehouse.
v-saisrao-msftCommunity Support
Hi ARatcliffeTP​,
Glad to hear that the issue got resolved. I think the issue may have been due to the cache. Please accept your reply as the solution, as it may help other community members who are facing a similar issue.
Thank you.
jubinsoniContinued Contributor
Glad it cleared up on its own. I think it usually means a background reference from a cancelled or half finished operation hasn't been cleaned up yet. Waiting a few hours, or until the next day, tends to fix it as this case shows. If it's still stuck after a day, check View item lineage for any hidden child items, and if there's nothing there, a support ticket is the way to get the reference removed.
Also worth knowing for the lab, some steps like creating semantic models work more smoothly in a regular workspace than in My workspace, so creating a dedicated workspace for labs can save a few headaches.