Forum Discussion
Unable to delete auto-generated Semantic Model (empty, no lineage)
Hi everyone,
I’m unable to delete an auto-generated Semantic Model (e.g. DataflowsStagingWarehouse1) in a Fabric-enabled workspace.
Context:
- The Semantic Model exists in the workspace
- It has no tables / no schema
- Lineage View shows no dependencies
- No reports or other artifacts are connected
- I’m Workspace Admin
Issue: When trying to delete it, I get:
Model_FailToRemoveDatasetMessage (400)
Even though the model is completely empty, deletion is blocked, which suggests a hidden backend dependency (possibly from Dataflows Gen2 / Warehouse / Lakehouse staging).
Questions:
- Is this a known Fabric issue?
- Is there any supported way to clean up these orphan Semantic Models?
- Or is Microsoft Support backend cleanup the only option?
Thanks in advance for any confirmation or guidance
Hi bdpr_95,
Interesting. THere should be nothing preventing you from deleting it.
Can you try using the API to delete it?
Items - Delete Item - REST API (Core) | Microsoft Learn
4 Replies
Hi bdpr_95,
How old is this model?
Dataflow Gen 2 does create staging lakehouse and warehouses that are hidden in the UI, that use the naming convention you mentioned.
Way back when, when default semantic models were a thing, these hidden staging datastores also had hidden default semantic models, but default semantic models have been gone for quite a while now.
If you open the lineage view of the model, what do you see?
No relation. Just the item:
Hi bdpr_95,
Interesting. THere should be nothing preventing you from deleting it.
Can you try using the API to delete it?
Items - Delete Item - REST API (Core) | Microsoft LearnProblem solved, thanks a lot!
