Forum Discussion
Server Name provided does not match the server name on the SQL Server SSL Certificate
From PowerBi Desktop, when connecting to a SQL Server using the servers FQDN and using either Windows Authentiation or Microsoft Account (with Microsoft Account being our perfered method), we get the...
To resolve the SSL certificate error in Power BI, create an environment variable PBI_SQL_TRUSTED_SERVERS with your SQL Server's name, then restart Power BI. This bypasses the server name mismatch issue.
Refer to the article