Mysql databse connection error 2147467259

[Anonymous]

Hello,

I'm having trouble to connect to a mysql database which shows an error message as follow:

DataSource.Error : MySQL : Fatal error encountered during command execution.
Détails :
DataSourceKind=MySql
DataSourcePath=51.77.158.29;samfm58_merial
Message=Fatal error encountered during command execution.
ErrorCode=-2147467259

I can see the tables in the database in PowerQuery but I can't seem to get a previous nor load anithing from the mysql db which I have a full access to and which i can load from MySQLQueryBrowser.

Does anyone ever had the same error and knows how to fix it?

Thanks in advance for the help

Thomas

[Anonymous]

@Anonymous I am facing exact issue. How did you resolve this problem?

Thanks!

[v-frfei-msft]

Hi @Anonymous ,

Please check this case.

https://community.powerbi.com/t5/Desktop/quot-Fatal-error-quot-when-using-MySQL-variable-in-query/td-p/201595