connection to databricks data source in Visual Studio fails with SSL error

[geertvanhove]

Hi,

I'm new to databricks but am positively surprised by the product. We use databricks delta tables as source to build a tabular model, which will serve as data source for Power Bi.

To develop our tabular model we use Visual studio to import tables and views from Databricks.

Since we had to generate a new token, this connection fails giving following error.

DataSource.Error: ODBC: ERROR [HY000] [Microsoft][ThriftExtension] (14) Unexpected response from server during a HTTP connection: SSL_connect: certificate verify failed.

Details:

DataSourceKind=Spark

DataSourcePath=https://westeurope.azuredatabricks.net:443/sql/protocolv1/o/...

OdbcErrors=[Table]

We use apache-spark-http as protocol. AuthenticationKind = UsernamePassword; UserName=token. Password=new token generated by databricks service.

Refreshing the model on azure analysis services works fine, there it uses the new token correctly to the databricks service. But any connection (import tables, schema refresh, ...) to the databricks data source in Visual Studio generates the SSL-error.

[Hubert-Dudek]

In Visual Studio do you use databricks-connect? Maybe it is enough to rerun "databricks-connect configure"

[geertvanhove]

Hi,

thanks for your reply.

Does this also count for Visual Studio ( not only Visual Studio Code)?

I'm using Visual Studio to manage a Tabular Model project.

[-werners-]

@geert vanhove​ , Is the combo Databricks/SSAS supported nowadays? Because I think about 6 months ago that was not the case.

MS advised using power bi or Synapse (Serverless).

[geertvanhove · Accepted solution]

this is fixed, it was linked to firewall settings

thanks

[Ion_Donica]

@geert vanhove​ , How did you achieve the successful connection between SSAS tabular and Databricks ? could you show a generic example?