Databricks

geertvanhove · ‎03-16-2022

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.

geertvanhove · ‎04-26-2022

this is fixed, it was linked to firewall settings

thanks

View solution in original post

Hubert-Dudek · ‎03-16-2022

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

geertvanhove · ‎03-16-2022

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- · ‎03-16-2022

@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).

Kaniz · ‎04-26-2022

Hi @geert vanhove , Just a friendly follow-up. Do you still need help, or have you resolved your problem with the above solutions? Please let us know.