We are facing an issue with the connection between Microsoft Excel and our MariaDB database using the MariaDB driver.
When trying to connect to the database in Microsoft Excel through Data -> Get data -> from other sources -> from ODBC, I select the DSN and get the databases shown, but not the list of tables (see attachment). Without seeing the tables, we are not able to use Power Query in Excel properly.
I've tested it with MariaDB ODBC driver 3.08 and 3.1.0 and both show no tables. When I do the same with the Mysql ODBC driver 8.0.15 I get the list of tables without problems.
I am niot sure if this is a bug in the mariadb driver, a compatibility issue or a misconfiguration from our side.
Could you sheed some light on this matter?
Thanks a lot for your support