cannot connect to Mysql database from Power BI desktop

[vinoddevathi]

Hi All,

Can anyone help me in connecting to Mysql databse.

 

I have installed mysql-connector-net 6.6.5 as per the below microsoft document

https://docs.microsoft.com/en-us/power-bi/desktop-data-source-prerequisites

Still I am getting this error. It would be greatful if you help us on this as I am working on critical project

[v-yulgu-msft]

Hi @vinoddevathi,

How did you connect to MySQL database? Did you directly use the "MySQL database connector"?

Based on my research, using a MySQL variable in query would cause such an error. If you input any query when creating the data source connection, please run the query in MySQL DB first to ensure it can return correct data.

Best regards,

Yuliana Gu

[vinoddevathi]

Hi @v-yulgu-msft,

I got this error while connecting through MySQL database connector. I have installed MySQL 6.6.5 connector in my system.

 

[vinoddevathi]

I have installed MySQL ODBC 5.3.9 as well and connected using ODBC connection but still I am getting below error.

Few weeks back, I connected through ODBC and it was working fine. But it is strange that now I am unable to connect through ODBC and native connection

[v-yulgu-msft]

Hi @vinoddevathi,

Could you please update your Power BI desktop to the latest version for a test?

Regards,

Yuliana Gu