PowerBI - MySQL - ODBC Error 42000 syntax

[hminemail]

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.

BI_KPIS_CLIENTES_DIARIO (2)

Failed to save modifications to the server. Error returned: 'Erro do OLE DB ou do ODBC : [DataSource.Error] ODBC: ERROR [42000] [MySQL][ODBC 8.0(w) Driver][mysqld-5.7.30]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.`BI_KPIS_CLIENTES_DIARIO`' at line 75. '

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.

[themistoklis · Accepted solution]

@hminemail 

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?

[hminemail]

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 answer

[hminemail]

IT WORKED!! THX really!