Connection Issues Between Fabric and Databricks SQL Warehouse Using Service Account

Hello Anonymous,
Thank you for reaching out to the Microsoft Fabric Community Forum.

Based on your setup, Fabric does not automatically use the service account when logged in with personal accounts. You’ll need to configure the service account credentials explicitly.

Use a service principal with AAD authentication first Create a service principal in Azure AD and Add it to the AD group (ITS-EP-AZR-DHL-DatabricksDataSQUsers) and assign Contributor role in the Fabric workspace then configure the service principal in Fabric’s Databricks.

• Avoid hardcoding credentials: use Key Vault for storage.
• Check the private endpoint allows the service principal’s identity. Verify network rules if issues persist.

Your attempts (PAT/AAD with personal accounts) likely failed due to missing service account context or permissions. The service principal method should resolve this.

If you have any further questions, please don't hesitate to contact us through the community. We are happy to assist you.

Best Regards,
Ganesh Singamshetty.