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.
I was able to connect to a MySQL database with direct query mode using this connector MariaDB Direct Query Adapter
In case anyone reads this whole thread, this is the solution. It worked perfect for me. It didn't occur to me to use the MariaDB connector to connect to MySQL. Thank you victorviro!!
to all those, who are disappointed by the fact that powerbi directQuery is not supported with mySQL- "this is not full truth."
mySql and mariadb are developed by same people, and are almost identical. so direct query connector/adapter for mariadb
also work for the mySQL.
1. just download it from above link.
2. select 'mariadb' in 'get data' option in powerbi
3. put your 'mySQL' server and database name.
4. select directQuery mode.
5. put in your mySQL credentials, and there you are.
additional: in case you want to publish your report to pbi service-
6. publish your pbi desktop direct query report to service.
7. install a on-premises data gateway on your machine (pc/server)
8. configure your data gateway in 'manage gateways and connections' in pbi service.
9. finally go to the dataset setting of the report you just published to pbi service, and connect your data gateway with your pbi dataset.
10. now whenever you update your mySQL database, and query your report (means open or interact with your report) over pbi service or desktop, that query will securely directly go into your database via that data gateway, and will fetch the updated data to the report, this way you'll see the updated report.
Thanks victorviro for suggesting this amazing trick.
I tried it, for the connection if it lets me do it, but when I make the relationships of the tables in power bi, I get errors, the same when making measurements, for example the following I am counting the amount of ticket, but filtering those that have id = 1, when I put it on a card I get that error
When I try to relate tables I get the same error
i don't understand what the error message does say.
However, here might be a fix- https://community.fabric.microsoft.com/t5/Desktop/Relationship-Direct-Query/td-p/2255900
super! what about if I'd like to edit a custom SQL query. The custom sql box is hidden, and I'm stuck on this. Many thanks
I get the following error when I try to connect to my MySQL database through MariaDB, with MySQL credentials:
"[ma-3.1.4]Can't connect to MySQL server 'localhost' (10061)"
What am I doing wrong?
All I'm doing is adding a table, and I get "This step results in a query that is not supported in DirectQuery mode" on the very first "Source" step...
