Power BI Refresh error

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.