In my previous blog post I had shown you how to backup your Microsoft Fabric Items: Backing Up Your Microsoft Fabric Workspace: A Notebook-Driven Approach to Disaster Recovery – FourMoo | Microsoft Fabric | Power BI

The next natural question is what happens when you want to restore one if the items that were previously backed up.

In the steps below I will show you how to do this.

In my working example I am going to restore the following items

Uploading your backup Items

Either you will have your Fabric items backed up to OneLake or Azure Blob Storage or to an alternative location.

To restore the items, they now need to be uploaded back into OneLake so that they can then be used as part of the restore (Or in the case of Fabric CLI the items need to be imported).

In my example I uploaded the files back into OneLake files section in my Lakehouse

Restoring Items

Next, I used a notebook to restore my items.

As in my previous blog post I first defined the variables which I will use in the later steps.

The only real change is the “restore_folder_location” as highlighted below.

The cells below then completed getting the Service Principal details, installing the Fabric CLI and authenticating. As shown below once this was completed, I could see I had successfully logged in.

The final code cell is where I am restoring all the items in my folder with the following Python code below (This code was created using the previous code and Claude).

I then ran this cell, and it ran through and tried to import the items.

As you can see above 2 items failed.

The first one that failed was the DataPipeline or Pipeline. The reason for the failure is that when it was importing it was looking for the previous connections, which it could not find and that is why it failed.

The second one that failed was CopyJob. The reason for the failure is that when it was importing it was looking for the previous connections, which it could not find and that is why it failed.

This was a learning experience for me as I just assumed it would still be restored and I could fix the connections later.

I would recommend that you test the restore of your items, so that you can identify which ones will restore and which ones will not restore.

Here is an example below of my semantic model which restored successfully.

Summary

In this blog post I have shown you how to restore your Fabric items from a backup.

You can find a copy of the notebook here: Fabric/Blog – Restore from Backup Items.ipynb at main · GilbertQue/Fabric

Thanks for reading!