Microsoft Fabric - Warehouse Service Principal Authentication Failure in Azure Data Factory & Python

[Sathish133]

Hi Team,

I am trying to connect the Microsoft Fabric Warehouse from Azure Data Factory(ADF) using Service Principal Authentication and same way trying to connect Microsoft Fabric Warehouse from Python (Local) using Service Principal Authentication, but both methods it is failing.

Steps implemented,
1) Service Principal created in Azure Portal with Client ID, Client Secret.
2) Microsoft Entra Security Group created and Service Principal assigned into it.

3) Provided Contributor access to the security group for the Fabric Workspace.
4) Fabric Admin Portal --> Tenant Setting --> Developer Settings --> Service principals can use Fabric APIs --> Enabled for the security group.

5) Fabric Admin Portal --> Tenant Setting --> OneLake settings --> Enbled the both options

ADF Error below :
Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'xxxx.datawarehouse.fabric.microsoft.com', Database: 'yyyy', User: ''. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.
Login failed due to invalid authentication methods.

Python Error below :

('28000', '[28000] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Login failed due to invalid authentication methods.

Am I missing anything ? Please suggest.

Regards,

Sathish Kumar

[Sathish133]

Hi,

I have reached out to Microsoft support and they suggested to give permission to Service Principal directly instead of Security Group.

Regards,

Sathish Kumar Mathivanan

[v-shex-msft]

Hi @Sathish133,

I'm glad to hear you find the root causes and share the resolution here, they should help others who faced the similar issues.

Regards,

Xiaoxin Sheng

[Sathish133]

Hi,

Anyone has idea on this ? What is causing the connectivity issue ?

Regards,

Sathish Kumar

[v-shex-msft]

HI @Sathish133,

I'd like to suggest you to take a look at the following link which mentions the same issue if it help with your scenario:

Azure Data Factory - Azure SQL connectivity error : Check the linked service configuration is correc...

Regards,

Xiaoxin Sheng

[Sathish133]

Hi,

The link provided specific to Azure SQL, but my case is Microsoft Fabric Warehouse.

Regards,

Sathish Kumar Mathivanan

[v-shex-msft]

Hi @Sathish133,

Have you checked the configuration about the managed private endpoint of the workspace?

Overview of managed private endpoints for Microsoft Fabric - Microsoft Fabric | Microsoft Learn

Regards,

Xiaoxin Sheng