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

Get Fabric certified for FREE! Don't miss your chance! Learn more

Reply
Yazdan
New Contributor III

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
BhaveshPatel
Honored Contributor

 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.
v-saisrao-msft
Honored Contributor III

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.

v-saisrao-msft
Honored Contributor III

Hi @Yazdan,

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

 

Thank you.

v-saisrao-msft
Honored Contributor III

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.

v-saisrao-msft
Honored Contributor III

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.

Helpful resources

Announcements
Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Free Fabric Certifications

Free Fabric Certifications

Get Fabric certified for free! Don't miss your chance.

January Fabric Update Carousel

Fabric Monthly Update - January 2026

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Users online (12,767)