Forum Discussion
Power BI Data Error
I am not sure if I am putting this in the right place but I currently have a power BI presentation and about 7 of the tables pull from a data bricks cluster. But I have been getting an error when I refresh 3 of them, all of the others are working. I don't know much about certificates or what the issue is.
2 Replies
Hi Anonymous ,
To resolve this error, you have a few options:
- You can use Microsoft OLE DB Driver for SQL Server 18.x. You can download the driver from [here].
- You can change the value of Encrypt/Use Encryption for Data setting in your application connection string property to No or Optional. For example, `Use Encryption for Data=Optional`.
-You can try downloading and installing the latest ODBC driver from the Databricks official website.
- You can add `;TrustServerCertificate=true` to your connection string. This will force the client to trust the certificate without validation.
- You can add the public key SQL Server certificate to all the Service Fabric nodes. Alternatively, you can contact the SQL Server database administrator to import the certificate to the client computer that installs Power BI Desktop.
- You can make sure that the certificate used by the SQL Server is within the Trusted Root Certification Authorities store of the machine running the Power BI Desktop.Please refer to the following documents for more information.
The certificate chain was issued by an authority that isn't trusted - SQL Server | Microsoft Learn
SSL Security Error with Data Source | Microsoft Power BI Blog | Microsoft Power BI
Certificate Chain Not Trusted Error Effecting Powe... - Power Platform Community (microsoft.com)
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
about 7 of the tables pull from a data bricks cluster.That is unrelated to your error message. Ask the DBA of the SQL Server to refresh the certificate.
