Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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
Hi @Anonymous,
Thanks for your sharing.
Regards,
Yuliana Gu
User | Count |
---|---|
91 | |
77 | |
71 | |
65 | |
58 |
User | Count |
---|---|
103 | |
94 | |
75 | |
61 | |
58 |