Ownership of Fabric Items

[Srisakthi]

Microsoft Fabric is an end-to-end, AI-powered data platform that integrates all stages of the data lifecycle such as ingestion, preparation, storage, analysis, and visualization into a single, cloud-based experience.

When a user leaves the organization, or if they don't sign in for more than 90 days, it's possible that any Fabric items they own will stop working correctly.

The Fabric items created by them are inoperative until ownership is transferred. Taking ownership of a parent item automatically transfers all associated child items, except for notebook activities and other related items in data pipelines, which must be taken over separately.

Let’s deep dive into ownership take over of Microsoft Fabric items.

1. What are all the items supported for ownership transfer
2. What kind of identity’s are supported for each item
3. How do we change via Powershell or portal?

Fabric Items	Ownership Change	Identity Type	Portal/ Powershell
Lakehouse	Available	User	Portal
Warehouse	Available	User/ SPN*	Portal/ Powershell
Notebook	Available	User	Portal
Data Pipeline	Available	User	Portal
Spark Environment	Available	User	Portal
Data Flow Gen2	Available	User	Portal
Semantic Model	Available	User	Portal
Data Agent	Available	User	Portal
Reports	Not Available	NA	NA

If Service Principal Name (SPN) to be set as Owner then powershell script to be utilised. This SPN change can be done only for warehouse. Other Fabric-item takeover doesn’t support for Ownership takeover as SPN.

Mirrored Databases are not support for Ownership change. We have to create new mirrored databases.

How to transfer Ownership:

Navigate to any supported Fabric items, click on settings, as highlighted below you can see Take over option

Once Take Over option is clicked then you will see the below screenshot for the confirmation and click Take over button , then automatically it will get transferred to your name.

As of now changing ownership to Service Principal is not available for items except warehouse.

Citations

Warehouse Ownership change - https://learn.microsoft.com/en-us/fabric/data-warehouse/change-ownership?tabs=portal

Item Ownership change - https://learn.microsoft.com/en-us/fabric/fundamentals/item-ownership-take-over