Direct Querying MySQL database

[sanchit]

Hi

Is it possible to Direct Query MYSQL database? If yes , how to do it ? If no , can you please help me with an alternative?

Thanks in Advance

[v-yulgu-msft]

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

[Greg_Deckler]

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