ERROR 400 - Credentials (SQL)

Hi jessicabonicenh ,

Since you have tried all the auth possibilities and the error persists, I suggest that you can check if the personal gateway you used is the latest version. If the gateway version is out of date, many problems arise.

And you can check as described below:

1, The username and password used to log in to the data source are not up-to-date. In Power BI, go to the refresh settings for your dataset. In Manage Data Sources, select Edit Credentials to update the credentials for the data source.

2, If one of the sources authenticates using OAuth, the combination of cloud and on-premises sources cannot be refreshed in the gateway (personal mode) in a single query. An example of this problem is the integration of CRM Online with an on-premises instance of SQL Server. Blending will fail to refresh because CRM Online requires OAuth.

Please refer to the following documents.

Troubleshooting Power BI Gateway (Personal Mode) - Power BI | Microsoft Learn

Best Regards,
Community Support Team _ xiaosun

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