Forum Discussion

dzav's avatar
dzav
Icon for Advocate III rankAdvocate III
1 year ago
Solved

Can't delete orphaned lakehouse SQL analytics endopoint and semantic model

I ran into an issue where I was using a Fabric deployment pipeline to deploying a lakekehouse from one workspace to another. This was meant as a temporary copy/migration method, so after it completed...
data warehouse
  • dzav's avatar
    dzav
    1 year ago

    It appears that there's an auto-cleanup process running in the background because after 2-3 days of waiting the orphaned lakehouse disappears. I've done this twice now for good measure.

v-csrikanth's avatar
v-csrikanth
Icon for Community Support rankCommunity Support
1 year ago

Hi dzav 
Could you please navigate to the workspace settings and you can delete orphaned semantic models. 
Your issue will get resolved.

 

If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.

  • dzav's avatar
    dzav
    Icon for Advocate III rankAdvocate III
    1 year ago

    I've tried deleting the semantic model twice. The first time it deleted and reappeared immediately, and the second time it also produced this error:

    Something went wrong

    Model_FailToRemoveDatasetMessage

    Please try again later or contact support. If you contact support, please provide these details.
     
    This also doesn't address the orphaned sql endpoint (aka mirrored warehouse).