Notebook New connection using Service principal

Hi DebbieE ,

Thank you for reaching out to Microsoft Fabric Community.

Fabric recently added automatic Notebook Connections, but they currently get created as personal user connections and cannot be parameterized, which breaks Dev/Test/Prod workflows.

As a Workaround:

Ignore the auto-created connection - don’t rely on it.Authenticate inside the Notebook using your Service Principal (client ID + secret).This makes the Notebook fully portable for all developers and all workspaces.You can safely delete the personal connection if it appears.

Hi DebbieE ,

If you are running the notebook through a pipeline, the following Microsoft documentations will help:

1.Notebook activity (pipeline execution + SPN/WI auth):

Notebook activity - Microsoft Fabric | Microsoft Learn

2.General guidance for notebooks (including support for parameters):

Develop, execute, and manage notebooks - Microsoft Fabric | Microsoft Learn

3.REST API for running notebooks (optional for external automation):

Manage and execute Fabric notebooks with public APIs - Microsoft Fabric | Microsoft Learn

Thank you.