Power BI to Aurora MySQL connetion - ODBC error

[Anonymous]

Hello Experts,

I have a AWS Aurora - MySQL database and I have created a ODBC connection with both USer DSN & System DSN connectors as shown. The TCP/Server mentioned is AWS Aurora endpoint for the database instance and the instance is running correctly.

Now in Power BI desktop in get data source, when I try to connect thorough ODBC connector with name MySQL, its saying the below error-

 

I am not sure what is causing this error, could anyone please advise?

Thank you

[Anonymous]

Some thing I just noticed, when I create a small table in mysql workbench create table wizard then this table is accessed using the same ODBC connector in power bi but one table is created directly by using CSV import and that table is giving the mentioned error in power bi.

Is this something related to dataset format or something related? The CSV file has data from SQL Server and I am loading this csv in Mysql.

Any help, please?

[Anonymous · Accepted solution]

Guys, please ignore this request. I figured this out using the following link

https://stackoverflow.com/questions/26673859/sql-server-migration-assistant-ssma-error-22018-mysqlod...

In case if anyone face this issue then, create the MYSQL OBDC with UNICODE and not with ANSI.

Thanks 

[v-yulgu-msft]

Hi @Anonymous,

Thanks for your sharing.

Regards,

Yuliana Gu