Certificate Chain Not Trusted Error Effecting PowerBI Only

Hi,christina4444 

Regarding the issue you raised, my solution is as follows:

In my test, using Microsoft account verification, the following error screenshot appeared:

1.If you have created a credential authentication method for sql data sources, you can edit the permission in the following page in the desktop:

https://www.c-sharpcorner.com/article/edit-or-remove-permission-from-existing-data-source-connection-from-power-bi/

2.First you need to open SQL server Configuration Management, open the project, and then restart the computer:

3.Log in to the database using window authentication:
 

4.Next, right-click on the server to open properties:

5.Select Security in the pop-up server tree menu, then select SQL server and windows Authentication Mode:

6.Log in to SQLserver as your domain user, change the password, and continue to restart the computer.

7.Then you can select "Database" in the SQLserver connection credentials, the following screenshot may appear, click "ok" can be.

8.The following relevant documentation hope to help you:

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

Power Query SQL Server connector - Power Query | Microsoft Learn

Best Regards,

Leroy Lu

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