Forum Discussion

sanchit's avatar
sanchit
Frequent Visitor
9 years ago

Direct Querying MySQL database

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
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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