Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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
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
Hello, when I arrive to step 2, and I open the ODBC source in PowerBI, there is a completely different window and my team and I are not sure where to go from here... any insight?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.