Data Bear

Fabric Workspace Takeover: Manage Projects After Staff Exit

growth assistance

When someone leaves a company suddenly especially without notice it can leave their projects, workflows, and data pipelines in limbo. In Microsoft Fabric, knowing how to perform a Fabric Workspace Takeover quickly is essential to keeping operations running smoothly.

Step 1  Get Access to the Workspace

Before you can manage anything, you must have the right permissions:

  • Admin
  • Contributor
  • Member

Once you’re in, locate the departed employee’s workspace in Fabric. Even if the name has been… creatively renamed, you’ll still be able to manage the items inside.

Step 2  Understand the Workflow Structure

Before taking over, review how the workflow is built. In our example:

  • Warehouse  Stores control tables containing “last modified” dates for checking updates.
  • Stored Procedure  Returns the last modified date.
  • Data Pipeline  Runs the stored procedure, then decides whether to execute a notebook.
  • Notebook  Uses PySpark to pull updated data into a Lakehouse.
  • Lakehouse  Stores the updated data for downstream use.Understand the Workflow Structure
Step 3  Taking Over a Warehouse
  1. Hover over the warehouse in the workspace.
  2. Select the ellipses (…) → Settings → About.
  3. Click Take Over.

Once complete, your credentials will be used for any data sources connected to that warehouse. If it connects to other warehouses or Lakehouses, ensure you have access to those too or update the connections.Taking Over a Warehouse

Step 4  Taking Over a Data Pipeline
  1. Open the pipeline.
  2. Go to Settings → About → Take Over.
  3. Important: Pipelines require you to change the “last modified” value before ownership is fully transferred. A simple trick is to edit the name slightly (add/remove a character), save it, then revert it.

Also confirm that:

  • You can connect to all referenced data sources.
  • Connection credentials are updated under Data Connections in Fabric.Fabric Workspace Takeover pipeline settings takeover button
Step 5  Don’t Forget Nested Items (Notebooks, Functions, etc.)

Taking over a pipeline doesn’t automatically give you control over the notebooks or other items it uses.

  • Go back to the workspace.
  • Open Settings → About → Take Over for each notebook, user-defined function, or related item in the workflow.Don’t Forget Nested Items (Notebooks, Functions, etc.) Fabric Workspace Takeover
Step 6  Post-Takeover Checklist
  •  Test data source connections.
  •  Verify pipeline schedules are still running.
  •  Confirm your credentials work with all external data sources.
Why This Matters

Without a proper Fabric Workspace Takeover process, a sudden employee departure can stall projects, break automated workflows, or even cause data refresh failures. By following these steps, you ensure your Fabric environment continues to run without interruption.

 Learn more about managing Fabric and Power BI with the Power BI Training from DataBear.