Forum Discussion
Power BI Refresh error
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:
- Anonymous4 years ago
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=0Refer to:
This is the related document, you can view this content:
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.
3 Replies
- amitchandakSuper User
Anonymous , Go to edit datasource, clear permissions and try again
or refer this
- AnonymousNot applicable
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.
- AnonymousNot applicable
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=0Refer to:
This is the related document, you can view this content:
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.