Connectivity

The server name doesn't match the SQL Server SSL certificate

Error code: ssl-name-mismatch

Power BI dataset refresh error — what it means and how to fix it.

What this means

A short server name was given but the certificate CN is the FQDN.

How to fix it

Use the FQDN in the gateway data-source and in the PBIX.
Republish the model.

View on Microsoft Learn

Related connectivity errors

DM_GWPipeline_Gateway_DataSourceAccessError
DM_GWPipeline_Gateway_MashupDataAccessError
Login timeout expired
The server was not found or was not accessible (SQL error 40)
Connection denied — Deny Public Network Access (Azure SQL)
The certificate chain was issued by an authority that is not trusted

Catch this automatically

RefreshRadar monitors every Power BI dataset refresh and alerts you the moment one fails — with the likely cause and the fix — so you never hear about a broken refresh from your stakeholders first.

Start free