Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThanks !!!
exactly I was looking for
sorry my english becouse I from Brazil
Humberto
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |