haje01's avatar
haje01
Regular Visitor
5 years ago
Status:
New

Import data from MariaDB with text filter raises SQL syntax error (Reproducible!)

Hi, I'm using PowerBI (version 2.92.706.0, 64-bit) and MariaDB as data source. I downloaded ODBC driver versions 3.1.11 from following link: https://mariadb.com/downloads/?showall=1&tab=connectors&...
Data Modeling
haje01's avatar
haje01
Regular Visitor
5 years ago

Thank you v-lili6-msft for your reply. I've installed new ODBC driver 3.1.12, still the error happens.

 

[ma-3.1.12][10.3.25-MariaDB-0ubuntu0.20.04.1-log]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'LONG VARCHAR) = ? and `PARTNERS` is not null' at line 11

 

Did you created test table with VARCHAR(256)? I found that VARCHAR less than 255 in length is okay.

 

Best,

Completed Ideas