Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
MH81003
Frequent Visitor

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. 

MH81003_4-1686673410130.png

 

 
 

 

 
 

 

2 REPLIES 2
v-tangjie-msft
Community Support
Community Support

Hi @MH81003 ,

 

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. 

lbendlin
Super User
Super User

 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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.