Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Ronald_ed
Frequent Visitor

Azure Databricks connection issues from PowerBI Service via VNET Gateway

Hello All,

 

We are trying to create connection from PowerBI Service to Azure Databricks with our VNET Gateway. 

Current Status:
- We can connect to Azure Databricks from PowerBI Desktop

- We can create a connection type - Azure Databricks Workspace but not Azure Databricks 

- We can publish Dataset directly from Azure Databricks to PowerBI Service - but not able to authenticate user. 

 

Error message when we try to create connection with VNET GW - connection type Azure Databricks (Azure Databricks Workspace works) 
Details: vnet-aut-dbx-aut-powerbi-dev-westeurope-snet-aut-dbx-aut-powerbi-01-dev-westeurope: ODBC: ERROR [HY000] [Microsoft][ThriftExtension] (14) Unexpected response from server during a HTTP connection: SSL_connect: certificate verify failed.

 

Authentication Error after I published dataset from Azure Databricks directly to PowerBI Service (for all auth. methods): 
Failed to update data source credentials: ODBC: ERROR [HY000] [Microsoft][ThriftExtension] (14) Unexpected response from server during a HTTP connection: Bad Status: Unrecognized response:HTTP/1.1 302 Found.

Auth. user to dataset from Databricks.pngVNET error.pngVNET_connection.png

Thank you for help 

1 ACCEPTED SOLUTION
Ronald_ed
Frequent Visitor

Hello, I solved the issue. Problem was with the certificates from Azure Databricks. I downloaded the certificate from the browser and then I´ve installed it on the server where the GW is. After this, I was able to create a connection from PowerBI Service to Azure Databricks with On premise data GW. 

Ronald_ed_0-1718089575431.pngRonald_ed_1-1718089588553.png

 

View solution in original post

3 REPLIES 3
Ronald_ed
Frequent Visitor

Hello, I solved the issue. Problem was with the certificates from Azure Databricks. I downloaded the certificate from the browser and then I´ve installed it on the server where the GW is. After this, I was able to create a connection from PowerBI Service to Azure Databricks with On premise data GW. 

Ronald_ed_0-1718089575431.pngRonald_ed_1-1718089588553.png

 

v-shex-msft
Community Support
Community Support

Hi @Ronald_ed,
Perhaps you use REST API to getting data from azure data bricks with anonymous authorizations, they should not require you to configure VNET settings.

Azure Databricks REST APIs | Microsoft Learn

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hello @v-shex-msft,

thank you for quick reply. Unfortunately, after some discussions with our security department we agreed on to use VNET gateway for such a connection. I would try to fix the VNET issues first.

Regards,

Ronald

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.