Compatibility Power BI Desktop with SQL (version mismatch?)

[DavidMo]

Hello,

I am working on building a set of SharePoint sites,  each will have a dashboard generated by Power BI (source of data -> ERP: Vista from Viewpoint)

While testing the connectivity of Power BI Desktop using the most recent version (v 2.140.1078.0) with Microsoft SQL Server Management Studio (v18.12.1), I encountered issues and was having an encryption support message ("Server name provided doesn't match the SQL Server SSL certificate").

When I downgraded Power BI Desktop to v 2.102.845, it does works.

Note: the most recent version of Microsoft SQL Server Management Studio (v 20.2) did not connect with our Server (SQL Server version 13.0.6455.2), this is why I use Microsoft SQL Server Management Studio v18.12.1.

I would like to make sure of the database compatibility going forward, allowing VPN connectivity and ensure that the data source setup is not altered with future version updates.

Which version of both Power BI Desktop and Microsoft SQL Server Management Studio would you recommend to ensure a flowless development? Should we also consider updating the SQL Server version? If so, to which one?

Thanks in advance for your support!

[Anonymous]

Hi @DavidMo ,

Based on the error meesage:"Server name provided doesn't match the SQL Server SSL certificate".

Here are steps to resolve this issue:

Ensure that the server name you are using in Power BI Desktop matches the Common Name (CN) or Subject Alternative Name (SAN) on the SQL Server's SSL certificate.

Consider installing a valid SSL certificate.

Best Regards,
Stephen Tao

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

[Greg_Deckler]

@DavidMo Sounds to me what you really need to do is update your SSL certificate so that the name of the server matches.