topic Re: Using Multiple %run Commands in Microsoft Fabric Notebooks in Data Engineering

Using Multiple %run Commands in Microsoft Fabric Notebooks

Yazdan — Fri, 10 Oct 2025 05:02:42 GMT

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!

Re: Using Multiple %run Commands in Microsoft Fabric Notebooks

BhaveshPatel — Fri, 10 Oct 2025 08:13:25 GMT

Hi @Yazdan

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

Re: Using Multiple %run Commands in Microsoft Fabric Notebooks

v-saisrao-msft — Mon, 13 Oct 2025 04:13:16 GMT

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.

Re: Using Multiple %run Commands in Microsoft Fabric Notebooks

v-saisrao-msft — Thu, 16 Oct 2025 05:00:22 GMT

HI @Yazdan,

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

Thank you.

Re: Using Multiple %run Commands in Microsoft Fabric Notebooks

Yazdan — Thu, 16 Oct 2025 21:32:10 GMT

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.

Re: Using Multiple %run Commands in Microsoft Fabric Notebooks

Yazdan — Thu, 16 Oct 2025 21:32:36 GMT

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.

Re: Using Multiple %run Commands in Microsoft Fabric Notebooks

v-saisrao-msft — Fri, 17 Oct 2025 04:02:48 GMT

Hi @Yazdan,

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

Thank you.

Re: Using Multiple %run Commands in Microsoft Fabric Notebooks

v-saisrao-msft — Thu, 23 Oct 2025 09:18:43 GMT

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.