Error when refreshing databricks on PBI

[MostafaGamal]

Hi All,

I have a PBI report using azure databricks as a data source, when i rereshed the data i got this error 

[v-yueyunzh-msft · Accepted solution]

Hi , @MostafaGamal 

PowerBI Desktop and Gateway can only use certificates in the System Trusted Cert Store. This may require administrative rights to the system. Make sure the certificate has been added.

Also consult this reference:

SSL Security Error with Data Source | Microsoft Power BI Blog | Microsoft Power BI

If you are still facing the issue, please install ODBC driver publicly available on the same machine and try to make SSL connection through that. For example in case of Impala data source: Install driver from:

Download Impala ODBC Connector 2.6.0 (cloudera.com)

Install it on the system. Go to Start -> ODBC data sources (64-bit) Configure ODBC DSN with SSL options as shown below:

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly