Power Query Problems

Fix SQL Server SSL Certificate Errors in Excel Power Query

Khadija KhanKhadija Khan Nov 18, 2026 868 views

Question details

The user needs to connect Excel Power Query to SQL Server when certificate validation fails during login.

Fix SQL Server SSL Certificate Errors in Excel Power Query
Product
Microsoft Excel Power Query
Device & OS
not provided
Scenario
Connecting to a SQL Server database from Excel Power Query over an encrypted connection.
Observed behavior
The connection reaches SQL Server but login fails because the server certificate or its issuing chain is not trusted.
Before you start

Record the full error message and the SQL Server name entered in Power Query. Ask your database administrator to check the certificate presented by that server.

Solution 1Recommended

Verify the SQL Server certificate and trust chain

Use this approach to restore a secure connection when the server certificate is untrusted or its chain is incomplete.

1
Check the server name

In Excel, open Data > Get Data > From Database > From SQL Server Database and check the server name you enter. Give that name to your database administrator so they can verify it matches the certificate.

2
Inspect the certificate

Ask the database administrator to inspect the certificate configured for SQL Server and confirm that it is valid, unexpired, and issued for the server name used in Excel.

3
Repair the trust chain

Ask the administrator to install the required intermediate certificates on the server and ensure the client computer trusts the issuing certificate authority. The administrator should follow your organization's certificate policies.

4
Retry the connection

In Excel, return to Data > Get Data > From Database > From SQL Server Database, enter the server and database details, and try connecting again.

Verify the SQL Server certificate and trust chain
Keep certificate validation enabled: Some newer connectors may offer an option to encrypt without validating the certificate. Use it only for temporary testing if available; it does not establish that the server is trustworthy.
Free Microsoft Office alternative

Work with Excel spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Excel file compatibility for an easy transition. It does not repair SQL Server certificate trust or the Excel Power Query connection.

Open and edit spreadsheets in a familiar interfaceCompatible with Microsoft Excel XLSX and XLS filesReview SQL Server data already saved in a spreadsheetUse a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why can Excel reach SQL Server but fail during login?

The network connection may succeed while certificate validation fails. An untrusted issuing authority, missing intermediate certificate, expired certificate, or server name mismatch can prevent the encrypted login from completing.

How do I check which server name Power Query uses?

In Excel, open Data > Get Data > From Database > From SQL Server Database and check the server name entered for the connection. Ask the administrator to confirm that it matches the server certificate.

Should I bypass certificate validation to connect?

If your connector offers that option, use it only for temporary testing. The permanent fix is to use a valid server certificate with a complete chain that the client trusts.

Who should install the missing certificates?

Ask your database or IT administrator to check the SQL Server certificate and its intermediate chain, and to configure client trust for the issuing authority according to your organization's policies.