Forum Discussion
PowerBI - MySQL - ODBC Error 42000 syntax
Im trying to connect PowerBI to our MySQL Database. I've installed ODBC and created the connection.
Till now it all worked fine. But when i try to select a Table and load it, i keep getting thir error.
I tried creating the ODBC connection Unicode and also ANSI, same error.
And i get this error for all the thousands os tables we have into our database.
I'm a begginner so it may be possible that i'm doing something very basic wrong. But i seached for a long time, and found no solution here.
Thanks for your time anyways.
You are sending a code to MySQL database through ODBC connection and it seems that the connection cannot translate part of the code (it may even be one single character).
You need to find the bit of the code that can not be translated from the ODBC connection.
If there is a manual then it is best you read it
Also why dont you use the native MySQL connection on PowerBI?
3 Replies
You are sending a code to MySQL database through ODBC connection and it seems that the connection cannot translate part of the code (it may even be one single character).
You need to find the bit of the code that can not be translated from the ODBC connection.
If there is a manual then it is best you read it
Also why dont you use the native MySQL connection on PowerBI?
There's no code being sent. Anyways.
How can i use the native connection for MySQL?
When i try to select MySql connection it says i need one or more components installed, i searched and everything sent me to ODBC.
How can i create the native connection?
thx for the answerIT WORKED!! THX really!
