Forum Discussion
Fabric Warehouse - Service Principal Connection
I want to build an application to write data into a Fabric Warehouse.
This article says that there are 2 ways to connection to a Fabric Warehouse SQL Endpoint:
https://learn.microsoft.com/en-us/fabric/data-warehouse/connectivity
In Microsoft Fabric, two types of authenticated users are supported through the SQL connection string:
- Microsoft Entra ID (formerly Azure Active Directory) user principals, or user identities
- Microsoft Entra ID (formerly Azure Active Directory) service principals
I am unable to find any guidance on how to configure the service principal connectivity.
Using a user principal via MFA authentication is not possible in my scenario.
Can someone please provide a step-by-step process to create the service principal, give it the necessary permissions in the Fabric WH, and use it to connect via the SQL endpoint?
Maybe this blog will help?
How to use service principal authentication to access Microsoft Fabric's OneLake - Sam Debruyn
7 Replies
- AndyDDC
Most Valuable Professional
hi WDarwish @I don't think there's any specific documentation in the fabric docs, but you can follow this guide here to create a service principal https://learn.microsoft.com/en-us/purview/create-service-principal-azure
then you give the service principal the required permissions in the workspace or on the warehouse itself.
then to use the service principal is going to depend on your application
I actually created the principal as per this very same guide. I cannot get that principal to show up within Fabric WH when sharing or setting permissions.
- AndyDDC
Maybe this blog will help?
How to use service principal authentication to access Microsoft Fabric's OneLake - Sam Debruyn
