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

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