How to connect MySQL database to Power BI for Direct Query/Real Time data using the correct drivers

A comprehensive guide on how to connect MySQL DB to Power BI for Direct Query or Real Time data analysis using the correct set of drivers. This video will clear all the doubts of making a connection from Power BI to your MySQL RDBMS by explaining which drivers are needed to make a Direct Query connection and/or Import connection.

Often time people need real time data in Power BI. Direct Query helps with just that but the native MySQL Connector Net does not support Direct Query so we show another helpful alternative with Maria DB ODBC driver to make use of Direct Query and in turn connect real time to your MySQL database

#PowerBI #DirectQuery #realtime #PowerBIMySQL #mysqldatabase #mysql #dataanalytics #mysql #mysqldb

[MsPriss]

Thank you!! I've been struggling to connect through MySQL. The Maria DB ODBC worked perfectly.

[shalinichede]

Very nice explanation. We were facing the same issue with our MySQL connection. We didn't have direct query option. Thanks for this.

[yashpreetkaur]

thank you my Mysql was not connecting to power BI at all but with maria db it works fine

[muhammedshadil]

thank you, man. For your helpful video.

[LesWillis-xhmz]

The question is, with direct query can you use a custom SQL query statement (as you could in the import query), rather than just selecting tables?

[driving_duo]

Bhai can you make a small real time project. Fetching data from a api and then automating it to give a real-time report. Please bhai make a video on this 🙏

[srikar]

Informative.. Thanks a lot!
But we cannot use queries in MariaDB driver right?

[delderf-cs]

Thanks for the video. I was able to connect to to our DB, but when I create relationships between tables I get SQL compilation errors. Do you know if there is a solution for this?

[srikar]

I am receiving below error when I try to select columns loaded from MySQL database.
Specially I select the column(that is generated by aggregation functions in SQL Query in the view that I am accessing). Any clue?

OLE DB or ODBC error: [Expression.Error] We couldn't fold the expression to the data source.

[SabirImtiaz]

It worked well until I started developing Power Apps. There it gives connection error, can't find ODBC.

[lakshmiprasanna]

After publishing into powerbi service, how it will work?

[trippydelica]

I have done all the steps but when I finally connect the DB to powerBI I get this error: Details: "The 'Driver' property with the value '{MariaDB ODBC 3.1 Driver}' does not match an installed ODBC driver." I downloaded ODBC version 3.1.20 as in the tutorial but it didn't work for me. Any solution?