Refresh Failures of Report using Databricks Connector as a Data Source

[lovelyvalencia]

We are using databricks as a source of our dataset in a power bi report.
But it is failing when we try to refresh it on Power BI online. We have done refreshing the report multiple times already but still giving us the same error:

Do you have any suggestions for this? It is highly appreciated.
Thanks in advance.

[venal]

@lovelyvalencia 

Please refer the below links.

https://stackoverflow.com/questions/55586935/odbc-error-hy000-microsoftdriversupport-1170

https://social.msdn.microsoft.com/Forums/en-US/a9ad2ab0-78e5-4022-b9e9-580586078803/databricks-conne...

If you have any queries, please let us know.

If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

BR

venal.

[v-shex-msft]

Hi @lovelyvalencia ,

According to the error message, it seems like you are using the wrong server name and port on power bi service side.  Can you please double-check datasoruce to confirm if you configured the same datasource and connection string on power bi server side?

How to Get Your Question Answered Quickly 

Power BI Databricks cluster 
Regards,

Xiaoxin Sheng