Forum Discussion

po's avatar
po
Icon for Post Prodigy rankPost Prodigy
2 years ago

Azure the server name provided does not match the server name on the sql server SSL certificate

Hi,   In both power bi service and desktop we can connect successfully to Azure sql database using the FQDN    <db_name>.privatelink.database.windows.net   when we use an unencrypted connection...
Need Help
v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
2 years ago

Hi, po 

 

Error: The server name provided doesn't match the server name on the SQL Server SSL certificate.

 

This error can occur when the certificate common name is for the server's fully qualified domain name (FQDN), but you supplied only the NetBIOS name for the server. This situation causes a mismatch for the certificate. To resolve this issue, make the server name within the gateway data source and the PBIX file use the FQDN of the server.

Troubleshoot gateways - Power BI | Microsoft Learn

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.