Notebook New connection using Service principal

[DebbieE]

So today i went into my Pipeline and Notebook and a Connection has shown up whereas before I just had Workspace ID and Pipeline ID. 

Thank fully I got admin to sort out a service principle in Azure but I have some issues.

1. Microsoft told me to parameterise everything. i cant parameterise this connection ID

2. It says Notebook and my name so even thorugh a service princaple has been used it seems to be a personal connection. 

This is useless when you want to push your code base back into main dev workspace. or for example if another developer pulls the codebase into their dev workspace to work on it. I have been using library variables for the workspace Id and Notebook ID, Everyone and every environment has there own. But this has really thrown it. 

So yes, is anyone else finding this and what can be done. Apart from waiting for microsoft to sort it out?

[v-venuppu]

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.