Unable to connect to MySQL in Desktop with identical Credentials to those used in On-Prem Gateway

Hi sjrrkb123 ,

ErrorCode=-2147467259 often represents invalid credentials for the datasets. In this case, please try to clear the credentials about MySQL in Power BI Desktop and reconnect to it.

If the same credential still could not work in Power BI Desktop but in Power BI Service, try to use another authentication method to connect.

In addition, whether have set encrption connection for it. If the connection is not encrypted, you'll be prompted with the following dialog.

Select OK to connect to the database by using an unencrypted connection, or follow the instructions to set up encrypted connections to SQL Server.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.