Forum Discussion

Timbaaaal's avatar
Timbaaaal
Advocate II
1 year ago
Solved

Multiple Semantic Model created by Lakehouse - Cannot delete

Hi, I published a dataflow Gen 2 yesterday which take data from 4 tables in one Lakehouse in order to create a new table in another LH (lets call it Gold). The gold LH was new and never had any tab...
data warehouse
  • v-csrikanth's avatar
    v-csrikanth
    1 year ago

    Hi Timbaaaal 
    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.

Timbaaaal's avatar
Timbaaaal
Advocate II
1 year ago

Hi, thanks for sharing.

I did came across this one as well. But in this case, the person is looking to delete the semantic model while keeping the lakehouse. looks like Microsoft doesn't want to have a Lakehouse without a semantic model (default), so this is expected behaviour.
In my case, I already deleted the original Lakehouse, but the SM didn't get deleted and on top of that I had multiple created when the Lakehouse got created by the dataflow.

 

But like people mentionned on the other post, underlying issue is that we should definitly have a way to delete artifacts in the workspace. But also full visibility (Staging, soft delete etc.) If they don't want us to mess up with dependencies, then they should put in place better control/visibility of dependencies, like they did with objects in Dynamics/Power Apps Solution.