Since the Power BI Feb 2024 release, all of the reports in our workspaces have had this SSL error: "The server name provided does not match the server name on the SQL Server SSL certificate ... " Eve...
We added an Environmental Variable on the local machine of the users using Power Bi Desktop. Adding the variable allowed us to move to the new June release!
Variable Name: PBI_SQL_TRUSTED_SERVERS
Variable Value: SQL Server Name <--enter your sql server name here
For multiple servers, you need to use a comma and space (, ) to separate each server in the value field. You can also use an asterisk (*) for servers of the same name.
Variable Name: PBI_SQL_TRUSTED_SERVERS
Variable Value: SQL Server Name01, SQL Server Name02, SQL Server Name03
or
Variable Name: PBI_SQL_TRUSTED_SERVERS
Variable Value: SQL Server Name*
Hope that helps!