Direct query mode in MySql databse

[EkutirSB]

We have MySql database and we need to generate BI reports from MySql. We need to enable "Direct Query" mode while designing Power BI so that whenever there is a change in source data, we can get the data refreshed just by refreshing the browser.

[Anonymous · Accepted solution]

HI @EkutirSB,

AFAIK, MySQL does not support the 'direct query' connection mode. In my opinion, I'd like to suggest you try to write a custom connector with odbc and enabled the 'direct query' option on it.
For detail operations steps, you can refer to the following links to know the more about them:

Enabling Direct Query for an ODBC based connector 

Getting Started with Data Connectors 

Connect to MySQL from Windows with ODBC 

Regards,

Xiaoxin Sheng