![]() ![]() To get data from MariaDB in PowerBI, import 'test' table then click 'transform data'. In MariaDB just create a table like this:Ĭreate table test (name varchar(256), score int(11)) PARTERS is the column name which I add filter to. 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 But when I add text filtering (equality check) in Power Query Editor, it raises SQL syntax error like this: I downloaded ODBC driver versions 3.1.11 from following link:Ĭonnection & Simple import job worked well. I'm using PowerBI (version 2.92.706.0, 64-bit) and MariaDB as data source. The following is my original post, so please refer to it and fix the problem. I reported about it to PowerBI community, but they couldn't help it since they (MS) don't have the ownership of MariaDB Connector. I found a bug of MariaDB Connector for PowerBI.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |