Connectivity
The server name doesn't match the SQL Server SSL certificate
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.
Frequently asked questions
- What does the "The server name doesn't match the SQL Server SSL certificate" error mean?
- A short server name was given but the certificate CN is the FQDN.
- How do I fix it?
- Use the FQDN in the gateway data-source and in the PBIX. Republish the model.
- Where does this Power BI refresh error appear?
- It appears in a Power BI semantic model's refresh history when a scheduled or on-demand refresh fails.
Related connectivity errors
Catch this automatically
RefreshRadar monitors every Power BI dataset refresh and emails you when one fails, with the likely cause and the fix, so you are not hearing about a broken refresh from your stakeholders first.