Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
MarcusJBrubaker
Frequent Visitor

Cannot Delete Lakehouse Issue

Yesterday I tried to delete some old test Lakehouses and was met with the error "This item couldn't be deleted. Please try again later." I'm able to delete other objects as normal. As a test I created a brand new Lakehouse using one of the sample datasets and I cannot delete this one either. I also tried this in my personal Fabric trial tenant where I'm a full admin. Again, I can't delete a Lakehouse. 

 

The two different tenants are in West US and South Central US(Texas). 

 

Is anyone else having this issue?

1 ACCEPTED SOLUTION
MarcusJBrubaker
Frequent Visitor

Update: If I first delete the one-time pipeline used to populate the Lakehouse, I'm able to delete the Lakehouse. It's like Fabric sees that something is connected to the Lakehouse and won't let me delete it. Is this expected behavior?

 

I tested again by creating a Lakehouse with a copy data pipeline, and a completely blank Lakehouse. The blank Lakehouse deleted with no problem. The other lakehouse would not delete until I deleted the associated pipeline first.

View solution in original post

28 REPLIES 28
marcuspaivio
New Member

I have the same issue. I am not able to delete the Staging Lakehouse and its underlying objects (Semantic model, SQL endpoint), even though there aren't any other related items in the workspace.... Any updates on the resolve?

Not really, we gave up and just have a "Test Flow" in the worskapce, which hides all other artificats and looks cleaner, but still quite bad.

bjorn99_
Frequent Visitor

Exactly the same issue here, why is it even enabled by default when creating a dataflow gen 2 as it makes everything way slower?

jesvytcan
New Member

Experiencing same issue here. Mistakenly tried to create a Fabric dataflow in a PRO workspace and whole workspace is now moved to Fabric Trial. I want to move it back to PRO but it won't let me delete this DataflowsStagingLakehouse. Says This item couldn't be deleted. Please try again later. We cannot stand service disruption with this workspace since many users see their reports here via APP.

Try to delete any dependencies of that artifact. I had to delete all objects being used by the artifact in order to delete it.  That method worked for me.

Update: I was finally able to delete the DataflowStagingLakehouse and it's related SQL Endpoint & Semantic model from my workspace (I do not see any other dependent objects). Looks like something finally synced-up on Microsoft's end. HOWEVER, I am still not able to move the workspace back to PRO licensing, with this error: "workspace cannot be reassigned because it includes Fabric items or you're attempting to move them across regions. This is not supported currently. Remove the Fabric items, or move the workspace within the same region, and then try again.". If anybody has a fix please let us know, I'll post here if I'm able to work around this later on. Thanks


@jesvytcan wrote:
with this error: "workspace cannot be reassigned because it includes Fabric items or you're attempting to move them across regions. This is not supported currently. Remove the Fabric items, or move the workspace within the same region, and then try again."

This is pure speculation on my part, but it is possible that the Fabric items you deleted are only soft-deleted as part of disaster recovery. If this is true, then the items still exist from Fabric's point of view. For reference:

Reliability in Microsoft Fabric | Microsoft Learn

 

It could also be a delay in Fabric updating its own tables (or whatever Fabric uses behind the scenes to track all the objects). It is possible that after a little while you will be able to reassign the workspace. 

I didn't find how to delete dependencies. The only object with the delete option is the DataflowsStagingLakehouse.

 

Vinzce_0-1702319229888.png

Thanks

egons
Regular Visitor

HI, I also have the same issue. I deleted all pipelines that were created for the lakehouse but I am still unable to delete it and it shows the same error, I couldn't find any other dependencies that could be connected to the stagging lakehouse. Is there another solution for this?

Hi @egons,

Can you please share screenshot of your error?

Thanks.

It's the same as shared previously. I upgraded my workspace from PPU to Trial, created a test Dataflow, went and deleted that data flow and then tried deleting the stagging lakehouse too, but I am unable to delete.

egons_0-1699869696742.png

 

Hi @egons ,

We don't have any other edge case I guess, can you please confirm whether you deleted all the dependency services? like data pipelines or notebooks, etc?

How can I check something like this? There are no other pipelines or notebooks or dataflows in that workspace.

 

The flow was simple - creating a dataflow gen2, closing it, deleting the flow and then trying to delete the stagging lakehouse. I didn't create anything extra.

Maybe it is because I didn't connect anything to dataflow, just closed it and then deleted?

Can you please share the stagging lakehouse @egons ?
Did you created this stagging lakehouse or is it auto created?

No I didn't create it, I preasume that it is auto created. 

 

As I said, I created only the Dataflow, and then when I deleted it, a stagging lakehouse popped up, which I also tried deleting but wasn't able to. What exactly should I share? These 3 objects were auto generated, the only "Delete" option is shown for Lakehouse.


egons_0-1699870916746.png

 

Hi @egons ,

I guess you are not owner of this stagging lakehouse so that might be the reason that you were unable to delete the lakehouse.

That's not the case, I am logged in with that Admin user.

Do you have any other artifacts in that workspace? The automatically created staging lakehouse is shared by all lakehouses, warehouses, dataflows, and pipelines within the same workspace.

It is similar in concept to SQL Server's TempDB. Think of the workspace as a server and the staging lakehouse as its storage are for TempDB and swap files.

This isn't a perfect analogy as the staging lakehouse doesn't exactly work this way, but the point is you can't delete it until you delete everything that could potentially use it. And if you did delete it, the moment you add a new lakehouse, warehouse, etc., the staging lakehouse will automatically be recreated.

Hi, thanks for the answer. I understand the concept of it, just not sure, why it is acting the way it is.

We firstly created it in a workspace which already had active reports and data models in there, but previously was as PPU, not Trial for Fabric. Then switched the workspace to trial and added that one flow and deleted it, this was when this happened on the first time.

 

Then, also with another user we replicated this issue in "My workspace" which was completely empty. Creating the dataflow, exiting out of it, then deleting the flow, and still weren't able to delete the staging lakehouse. There was also a staging warehouse created which we were able to delete.
Here, it also shows only the lakehouse and all other tabs are empty.

 

egons_0-1699946168369.png

 

Hi @egons ,

We have a bug filed, to delete the LH & WH upon deletion of the last.
Ideal workaround is to create a new Workspace as we cannot delete the stagging artifacts manually.

If in your case if that will not work,  I request you create a support ticket so the team will be looking into this issue more closely.

Once you have a SR# , please do share that here, so that we can keep an eye on the same.

Hope it is helpful.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Fabric Monthly Update - February 2024

Check out the February 2024 Fabric update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.