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!
