Direct Querying MySQL database

I don't believe that the MySQL connector supports Direct Query.

https://community.powerbi.com/t5/Developer/Direct-query-with-mySQL-using-Power-BI-Embeded/td-p/46045

Hi sanchit,

PowerBI doesn't support to connect to MYSQL database using Direct Query. If you only want to use MYSQL as data source, it is only allowed the connection in Import mode. Alternatively, if you really need to use Direct Query, you can choose other databases, like SQL Server.

Thanks,
Yuliana Gu