u/Snoo-46123

Great news for teams building enterprise-grade CI/CD workflows with Microsoft Fabric Warehouse!

Service Principal (SPN) support for Fabric Warehouse Git Integration and Deployment Pipelines is now available, enabling fully automated, non-interactive deployment workflows. This removes a key blocker for organizations that rely on service principals for DevOps automation and governed release management.

With this update, you can:

• Use Service Principals with Git-based CI/CD workflows
• Automate commit, sync, and deployment operations without user credentials
• Enable enterprise-ready DevOps pipelines using Azure DevOps or GitHub
• Improve security by avoiding dependency on individual user accounts
• Standardize deployment automation across development, test, and production environments

This enhancement is part of our broader investment in Fabric Warehouse developer experiences, Git integration, deployment pipelines, and automation scenarios. Fabric Warehouse already supports source-controlled development and deployment workflows, and SPN support unlocks the final piece required for many production-grade DevOps implementations.

Coming next:

• Item Definition APIs for Warehouses
  • Create/Get/Update Warehouse with Item Definition
  • Support for both DACPAC and SQL Database Project (.sqlproj) definitions, enabling richer integration with existing SQL development workflows.
• Fabric CI/CD package Integration
  • Deploy Warehouse item definitions directly through fabric ci-cd package.

What CI/CD scenarios are you planning to automate now that SPN support is available?

The current API https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/warehouses/{warehouseId}/connectionStringapi
returns the server name, not a full connection string.

We’re evaluating whether this API should instead return the complete connection string.

Would this change break any of your scenarios or assumptions? Ex: If you’re currently constructing the connection string yourself using the server name, would this introduce conflicts or duplication?