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 ...
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

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