Forum Discussion
Power BI to Aurora MySQL connetion - ODBC error
Guys, please ignore this request. I figured this out using the following link
In case if anyone face this issue then, create the MYSQL OBDC with UNICODE and not with ANSI.
Thanks
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?
Guys, please ignore this request. I figured this out using the following link
In case if anyone face this issue then, create the MYSQL OBDC with UNICODE and not with ANSI.
Thanks
v-yulgu-msftMicrosoft Employee
Hi Anonymous,
Thanks for your sharing.
Regards,
Yuliana Gu