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

[sjrrkb123]

As the title says, I have a my_sql database that is used for Power BI reporting. There is a connection on PBI Desktop that has the exact same connection string and credentials as that of the on-premesis way. The on-premesis gateway has had zero problems refreshing this PBI report online but I am unable to connect to this same my_sql database on my desktop.

Here is the error I am receiving in desktop:

DataSource.Error: MySQL: Authentication to host '*****' for user '**' using method 'mysql_native_password' failed with message: Reading from the stream has failed.
Details:
    DataSourceKind=MySql
    DataSourcePath=**.***.**.**;***
    Message=Authentication to host '**.***.**.**' for user '**' using method 'mysql_native_password' failed with message: Reading from the stream has failed.
    ErrorCode=-2147467259

Also, I can connect to this database using MySQL Workbench without issues with the exact same credentials.

The last time I was able to connect successfully in desktop was in the end of September 2021. Note, this report does not get modified often but we will be archiving some data in the near future and I need to adjust where data is being sourced in Power Query.

Edit: PBI desktop and gateway are all up to date

Any help would be appreciated greatly!

[sjrrkb123]

 That did it ty.

[v-yingjl · Accepted solution]

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.