Error message when refreshing the data in power bi desktop

Given community solved issue may help you.

Solved: Certificate Chain Not Trusted Error Effecting Powe... - Microsoft Fabric Community

SSL Security Error with Data Source | Microsoft Power BI Blog | Microsoft Power BI

Solved: Refresh Issues PowerBI SQL database- Connection wa... - Microsoft Fabric Community

Troubleshoot scheduled refresh for Azure SQL databases - Power BI | Microsoft Learn

Power Query SQL Server connector - Power Query | Microsoft Learn

OR follow below steps:

1. Update Power BI Desktop: Ensure you have the latest version of Power BI Desktop installed. Sometimes, simply updating the software can resolve connectivity issues1.

2. Check the Trusted Root Certificate: Verify that the certificate used by SQL Server is in the Trusted Root Certification Authorities store on the machine running the Data Management Gateway. You can use the Microsoft Management Console (MMC) to do this2.

3. Switch Connection Type: Try switching the connection type from your Microsoft account to Windows authentication. This has helped others overcome similar SSL-related errors1.

4. Import the SSL Certificate:

   • Export the certificate from the server where SQL Server is installed.
   • Import the certificate into the Trusted Root Certification Authorities store on the client machine where Power BI Desktop is installed1.

5. Environment Variable: Add the environment variable PBI_SQL_TRUSTED_SERVERS with the problem server name. This can sometimes resolve the issue1.

6. Uncheck Encrypt Connection: Go to Home Tab -> Transform Data -> Data Source Connections, then edit permissions and uncheck "Encrypt connection"3.