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

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

Reply
Yazdan
Advocate II
Advocate II

Using Multiple %run Commands in Microsoft Fabric Notebooks

Tip: Using Multiple %run Commands in Microsoft Fabric Notebooks

 

I recently discovered something useful when working with multiple notebooks in Microsoft Fabric using the %run magic command.

 

When you try to load more than one notebook in the same cell like this:

 

%run NB_Slv_Logger
%run NB_Slv_Email_Configuration

 

You’ll get an error saying that no other code or commands can be combined with %run, and that no code can appear above or below the magic %run command in the same cell.

Even separating them with an empty line doesn’t work:

 

%run NB_Slv_Logger
 
%run NB_Slv_Email_Configuration

 

Result: Error – Fabric doesn’t allow multiple %run statements or any extra code in the same cell.

 

Solution:
Place each %run command in its own separate code cell.
Example:

 

# Cell 1
%run NB_Slv_Logger

 

 
# Cell 2
%run NB_Slv_Email_Configuration

 

After running both cells, you’ll have access to all functions, classes, and variables from both notebooks within your current notebook.


Key takeaway

Each %run must be executed independently in its own cell — no other code should exist above or below it. Once both are run, their code is fully imported and available.

 

Hope this helps anyone integrating multiple shared notebooks (e.g., for logging, configuration, or utilities) in Fabric!

7 REPLIES 7
v-saisrao-msft
Community Support
Community Support

HI @Yazdan,

Checking in to see if your issue has been resolved. let us know if you still need any assistance.

 

Thank you.

Hi,

As you can see in my post, this is not a problem or issue — I just shared my finding and solution for running multiple %run commands.

 

Thank you.

HI @Yazdan,

Thank you so much for sharing this, This kind of post is incredibly valuable to the community. Definitely consider turning this into a blog post so others can benefit from your experience more easily

Power BI Community Blog - Microsoft Fabric Community

 

Thank you.

v-saisrao-msft
Community Support
Community Support

Hi @Yazdan,

Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.

 

Thank you.

Hi,

As you can see in my post, this is not a problem or issue — I just shared my finding and solution for running multiple %run commands.

 

Thank you.

Hi @Yazdan,

Thank you for providing your insights. Kindly accept your response, as it will be beneficial to other community members.

 

Thank you.

BhaveshPatel
Super User
Super User

 Hi @Yazdan 

 

%run command is used for Global Parameters in Microsoft Fabric or Equivalent to Databricks Delta Lake.

 

BhaveshPatel_0-1760083738308.png

 

 

 

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

Helpful resources

Announcements
June Fabric Update Carousel

Fabric Monthly Update - June 2026

Check out the June 2026 Fabric update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.