Forum Discussion

hbuzzi's avatar
hbuzzi
New Member
9 years ago
Solved

query mysql

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

Need Help
  • MFelix's avatar
    MFelix
    9 years ago

    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

2 Replies

  • MFelix's avatar
    MFelix
    Super User
    9 years ago

    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's avatar
      hbuzzi
      New Member
      9 years ago

      Thanks !!!

      exactly I was looking for

       

      sorry my english becouse I from Brazil

      Humberto