Excel Power Query issue with MariaDB ODBC driver

[pierrebenko]

Dear Community,

I am encountering an issue in Power Query (M365) when utilizing the MariaDB ODBC Connector (version 3.2.4, latest) with MariaDB 10.11.6 (latest version for Synology NAS).

When attempting to query a table from MariaDB, the Navigator successfully lists all available tables. However, upon selecting a table, the preview fails to load and displays the following error:

DataSource.Error: ODBC: ERROR [42000] [ma-3.2.4][10.11.6-MariaDB] 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 'ORDER BY FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, KEY_SEQ, PKTABLE_NAME'

Notably:

• The table can be accessed without issues using the same DSN in HeidiSQL.
• A SELECT statement in the Advanced Options within Power Query works as expected.
• This problem does not occur when using the MariaDB ODBC driver version 3.1.20.

Could this behaviour be a configuration issue on my end, or is it potentially a bug with Excel PowerQuery?

I would appreciate any insights or guidance on resolving this.

Thank you in advance!

Best regards,
Peter

[Anonymous · Accepted solution]

Hi @pierrebenko ,

Based on the information you provided, it appears that the issue might be related to a change or bug in the MariaDB ODBC Connector version 3.2.4.

-- This problem does not occur when using the MariaDB ODBC driver version 3.1.20.
Given that the problem does not occur with version 3.1.20 of the ODBC driver, you could consider downgrading to that version until a newer version of the driver is released that addresses this issue.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[pierrebenko]

Hi @Anonymous,

Thank you for your prompt response.

I have already downgraded the driver, which appears to be a temporary solution. However, I’m curious—if the ODBC driver itself caused the issue, wouldn’t I encounter the same problem when using HeidiSQL?

Looking forward to your insights.

Best regards,
Peter

[Anonymous]

Hi @pierrebenko ,

The problem may be specific to a few versions of the driver or Excel, or it may affect a wider range of tools.
In any case, the recommended next step is to contact the MariaDB ODBC driver or Excel support to determine the cause of the problem.
You can open a ticket here to bring this to the developer's attention. Here is an example.

[ODBC-225] Excel+MariaDB driver not showing list of tables - Jira

If you also need Excel support:
Contact Microsoft Office Support - Microsoft Support

Best Regards,
Gao
Community Support Team