Cannot detach data item from notebook

[NotebookEnjoyer]

Hi, the title is pretty much self-explanatory. The "Remove" option is greyed out. What is going on?

[deborshi_nag · Accepted solution]

Hello @NotebookEnjoyer 

What you're experiencing is how Fabric Notebooks are designed to behave!

In a Fabric notebook, only ONE Warehouse can be the “primary” Warehouse. The first attached Warehouse becomes permanently bound. That primary Warehouse can never be removed. Any additional Warehouses are secondary and can be removed. You can try this with the other Warehouse you have attached. 

It seems the one you tried to remove is the first Warehouse you attached to your notebook. 

Fabric internally assigns the first Warehouse as Notebook SQL execution context. So it follows this rule

First Warehouse = permanent

Subsequent Warehouses = optional

If you want to “change” the primary Warehouse:

1. Create a new notebook
2. Attach the desired Warehouse first
3. Copy notebook content
4. Delete the old notebook

This is the only supported way to change the primary Warehouse.

[deborshi_nag]

Hello @NotebookEnjoyer 

The workaround mentioned by @Srisakthi is valid, however I don't think that applies to your case. I looked closely at your screenshot to identify the type of data item you're dealing with - in your case it is a Warehouse, although you've named it BC_140_TEST_Lakehouse.

The "Set as default lakehouse" option will show on a Lakehouse, not on a Warehouse item! The first Warehouse you add to your Notebook is permanent - you can't delete that, for reasons I mentioned in my first response to you. 

[Srisakthi]

Hi @deborshi_nag ,

You are right , we cannot do it on "Warehouse". But once we attach a lakehouse to notebook(which is already attached with warehouse first) in my case it allows to remove warehouse. Fabric automatically assign lakehouse as default.

Thanks,

Srisakthi

[Srisakthi]

Hi @NotebookEnjoyer ,

If you want to remove the lakehouse , choose some other lakehouse as Default and then try removing the lakehouse, it will get removed.

Step 1: In this sample i have two lakehouses attached to my notebook, the first one with pin symbol is default,so you cannot remove it.

Step2: Set the second lakehouse as default,

Step 3: Now you will be able to see the option for the lakehouse which you want to remove as it becomes not default

Thanks,

Srisakthi

[Srisakthi]

Hi @NotebookEnjoyer ,

If you want to remove the lakehouse , choose some other lakehouse as Default and then try removing the lakehouse, it will get removed.

Step 1: In this sample i have two lakehouses attached to my notebook, the first one with pin symbol is default,so you cannot remove it.

Step2: Set the second lakehouse as default,

Step 3: Now you will be able to see the option for the lakehouse which you want to remove as it becomes not default

Thanks,

Srisakthi

[RamiroD · Accepted solution]

Hi, same problem, the solution that i found was deleting all sources from the OneLake source and then adding them again.

[NotebookEnjoyer]

Amazing, it works.

[deborshi_nag · Accepted solution]

Hello @NotebookEnjoyer 

What you're experiencing is how Fabric Notebooks are designed to behave!

In a Fabric notebook, only ONE Warehouse can be the “primary” Warehouse. The first attached Warehouse becomes permanently bound. That primary Warehouse can never be removed. Any additional Warehouses are secondary and can be removed. You can try this with the other Warehouse you have attached. 

It seems the one you tried to remove is the first Warehouse you attached to your notebook. 

Fabric internally assigns the first Warehouse as Notebook SQL execution context. So it follows this rule

First Warehouse = permanent

Subsequent Warehouses = optional

If you want to “change” the primary Warehouse:

1. Create a new notebook
2. Attach the desired Warehouse first
3. Copy notebook content
4. Delete the old notebook

This is the only supported way to change the primary Warehouse.