Forum Discussion
Direct query mode in MySql databse
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.
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
1 Reply
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