Forum Discussion
Connect MaridDB to Power Bi
I am wanting to connect MariaDB ( hosted on AWS server ) to Power BI for analysis. 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.
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 -> ODBC, find this source you created. Then you can import data to PowerBI.
Regards,
Lydia
2 Replies
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 -> ODBC, find this source you created. Then you can import data to PowerBI.
Regards,
Lydia