Direct query mode in MySql databse

EkutirSB — Thu, 21 May 2020 09:18:46 GMT

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.

Re: Direct query mode in MySql databse

Anonymous — Fri, 22 May 2020 06:42:16 GMT

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

topic Direct query mode in MySql databse in Developer

Direct query mode in MySql databse

Re: Direct query mode in MySql databse