garddolau's avatar
garddolau
Icon for Advocate IV rankAdvocate IV
5 months ago
Status:
New

Support Service Principal for T‑SQL Notebook Execution

Make T‑SQL notebook execution fully compatible with Service Principals by removing or replacing internal OBO calls that reject SPNs.

 

When pipelines or automated runs execute Fabric notebooks using a Service Principal (SPN), T‑SQL notebook cells can fail because internal Fabric calls use an on‑behalf‑of (OBO) authentication flow that does not accept SPNs. This breaks CI/CD, scheduled jobs, and automation that must run under non‑user identities.

 

Request:

  • Ensure T‑SQL notebook execution does not rely on OBO flows that reject Service Principals.

  • Make notebook runtime APIs and internal calls accept Service Principals consistently.

  • Publish clear documentation listing required permissions and recommended configuration for Service Principals when running notebooks.

See error here: (Moving to Stored procedures is step backwards we want move forward with -t-sql notebooks for enterprise scale usage ) https://community.fabric.microsoft.com/t5/Data-Engineering/Fabric-Pipeline-T-SQL-Notebook-and-Service-principal/m-p/5139358#M15589

1 Comment

  • ga4f's avatar
    ga4f
    Regular Visitor

    I'm facing the same issue, how the heck they say that is GA. 

    Hoping for a improvement.

Recent ideas