This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 82%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBB%3C/text%3E%3C/svg%3E)
Hello,
We have set up Azure Databricks with Private endpoint enabled and public access disabled.
In the same Vnet we have set up an On-Prem PowerBI gateway.
Everything in the Vnet that is going outside of Vnet is routed to Azure FW.
All traffic inside Vnet is routed inside Vnet.
The connection is working to PowerBI when we set up On-prem datagateway.
We have added PowerBI required port rules in Azure Firewall.
But when we try to add data connection in powerBI portal to the private endpoint enabled Databricks workspace we receive this error:
Unable to create connection for the following reason: Unable to connect to the data source. Either the data source is inaccessible, a connection timeout occurred, or the data source credentials are invalid. Please verify the data source configuration and contact a data source administrator to troubleshoot this issue.
Details:
DataGatewayFolksamFade: ODBC: ERROR [HY000] [Microsoft][ThriftExtension] (14) Unexpected response from server during a HTTP connection: SSL_connect: certificate verify failed.
Please have this information handy if you choose to create a support ticket.
Session Id: 4e85629e-1bce-4ac0-90c5-715d1f78969b
RequestId: af12ad94-4456-4e3f-9e28-d71077ba4fa6
Cluster URI: https://api.powerbi.com
Status code: 400
Time: Thu Sep 28 2023 10:27:06 GMT+0200 (Central European Summer Time)Please have this information handy if you choose to create a support ticket.
Session Id: 4e85629e-1bce-4ac0-90c5-715d1f78969b
Cluster URI: https://api.powerbi.com
Time: Thu Sep 28 2023 10:27:06 GMT+0200 (Central European Summer Time)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Hello bengt bengan,
Welcome to the Microsoft Q&A forum.
The error you are getting is generally due to the incorrect hostname and HTTP path.
Please check if the server hostname and HTTP path are correctly copied from the Databricks JDBC/ODBC tab?
https://learn.microsoft.com/en-us/azure/databricks/partners/bi/power-bi
also, please check if you installed the correct driver on the machine where Power BI is installed.
https://docs.databricks.com/en/integrations/jdbc-odbc-bi.html
Hello bengt bengan,
I am checking to see if you got a chance to look into my earlier response. Please let us know if you have any further questions.
Hello bengt bengan,
I am checking to see if you need any further help here.
Hello,
We have added the HTTP path from a cluster that is running in Azure Databricks. The connection works if we do a test connection from Microsoft OBDC Spark driver from the VM that is Data Gateway.
So my guess is that there some kind of Firewall port block that is not documented for Databricks with Private Endpoint.
But for the ODBC connection to work from the VM inside the Vnet we had to add these settings.
Hello bengt bengan,
Did you get a chance to look into my above response?
Please let me know if you have any further questions.
Hello bengt bengan,
on the SSL options, please check "use system trust source"
A similar issue was discussed on the below threads and it helped some community members.
https://stackoverflow.com/questions/73497033/connectivity-issue-from-power-bi-to-azure-databricks
Please try the solution and let us know if you still face any issues.