Forum Discussion
Excel Power Query issue with MariaDB ODBC driver
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 TeamIf 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
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
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