Connect MaridDB to Power Bi

Question

I am wanting to connect MariaDB ( hosted on AWS server ) to Power BI for analysis.&nbsp; I looked up online the bunch of solutions and nothing seemed to work. I'm not sure if I'm looking into the right resources? Can somebody point me to the right resources for getting this task done?Thanks for any help.

anonymous · Accepted Answer

rabbal1892&nbsp;,
According to your description, my understanding is that you want to use PowerBI desktop to connect to MariaDB source. For MariaDB, we can create an ODBC source for it.
But based on my test, I found that when I use MariaDB ODBC driver of any version to create the ODBC source, it will not display the table list. Here is an issue opened: https://jira.mariadb.org/browse/ODBC-225 , as a workaround, we can use the MySQL ODBC driver to create the source. Please refer to the following steps:
1. Download the MySQL ODBC driver from: https://dev.mysql.com/downloads/connector/odbc/ and install it. (the platform 32/64-bit of ODBC driver depends on your PowerBI platform)2. Open ODBC data source tool (32/64-bit depends on the PowerBI desktop platform), add a new one, select the mysql odbc unicode driver. Then type the connection information.
3. After that, open PowerBI desktop, get data -&gt; ODBC, find this source you created. Then you can import data to PowerBI.Regards,Lydia
&nbsp;

Forum Discussion

Related content

Power BI Oracle Connection Error – ORA-50201 (Failed to connect / parse connect string)

Power BI MCP Server not connecting to Power service

Power BI Connect to Fabric

Connect Microsoft 365 Lighthouse Power BI

Connecting Power BI to Deltek Vantagepoint API