query mysql

[hbuzzi]

I am new in powerbi.

I want conect to mysql but i want put the query thats use many tables, joins, where,,, 

when i select mysql, powerbi show me tha tables and i dont find local that I can put my query,

anybody can help me?

Humberto Buzzi

[MFelix · Accepted solution]

Hi @hbuzzi,

I don't have any MySQL connection however in SQL/ODBC view when you are at the first screen where you select the database you have ADVANCE OPTIONS (last option with a down arrow on the right side) if you open that you can then write your SQL Statment, and after if you need to change it also available in the query editor.

Regards,

MFelix

[hbuzzi]

Thanks !!!

exactly I was looking for

sorry my english becouse I from Brazil

Humberto