- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-16-2022 05:47 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-16-2022 07:22 AM
In Visual Studio do you use databricks-connect? Maybe it is enough to rerun "databricks-connect configure"
My blog: https://databrickster.medium.com/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-16-2022 07:43 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-16-2022 07:56 AM
@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).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-26-2022 11:55 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-26-2022 03:15 AM
@geert vanhove , How did you achieve the successful connection between SSAS tabular and Databricks ? could you show a generic example?
