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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.