Forum Discussion
Direct Query MySQL
MySQL is currently not supported. You can see a list of all currently supported data sources for Power BI that can be used with Direct Query here.
There is an open UserVoice request for Direct Query MySQL support here.
MySQL is currently not supported. You can see a list of all currently supported data sources for Power BI that can be used with Direct Query here.
There is an open UserVoice request for Direct Query MySQL support here.
Yeah, no, there is a workaround. Just use MariaDB connection as mentioned in the above thread.
Thanks for the update Anonymous
You'll note the original thread started in 2019 and my reply was in march of 2020. Mariadb didn't support Power BI until December of 2020. So then, there was no workaround. Today, there is. Glad to know this.
I did see that, I just wanted to point anyone who came here looking for that answer in the right direction. That workaround saved my behind!😅
Hi edhans AL___ navinrangar Roger14 Anonymous !
Have you found any other solutions for this case?
i don't think any other solution is required.
mySql and mariadb works almost the same, thus the connector for mariadb works for the mysql as well.
It's possible with the correct drivers. Refer this video:
