Power BI Refresh error

[Anonymous]

Hi guys,

I receive the below error when I try to refresh. The data source used is databricks. Can anyone help me incase if you have faced the same error before? I have attached the image below:

[Anonymous · Accepted solution]

Hi  @Anonymous ,

If the proxy server does not provide a CRL distribution point (CDP), Power BI may show the error message .

To fix this error, complete the following steps:

Create the file C:\Program Files\Microsoft Power BI Desktop\bin\ODBC Drivers\Simba Spark ODBC Driver\microsoft.sparkodbc.ini if it does not exist.

Add the following config to your microsoft.sparkodbc.ini file:

[Driver]

CheckCertRevocation=0

Refer to：

https://docs.microsoft.com/en-us/azure/databricks/integrations/bi/power-bi#automated-http-proxy-detection

This is the related document, you can view this content:

https://docs.microsoft.com/en-us/azure/databricks/kb/bi/powerbi-proxy-ssl-configuration#disable-certificate-revocation-checking

https://community.powerbi.com/t5/Desktop/Power-BI-Desktop-amp-Self-signed-certificates/td-p/1684368

https://community.powerbi.com/t5/Power-Query/SSL-Certificate-Issue-can-I-ignore-it/td-p/91646

Best Regards,

Liu Yang

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

[amitchandak]

@Anonymous , Go to edit datasource, clear permissions and try again

or refer this

https://community.powerbi.com/t5/Power-Query/Certificate-Chain-Not-Trusted-Error-Effecting-PowerBI-Only/td-p/359157

[Anonymous]

Thank you. I tried to login to my Azure active directory but it failed to login and I was unable to edit the data source.