How to write MySQL queries in editor query to fecth data and make visualization ?

H v-qiuyu-msft,

Thank you for the response. I worked on mysql queries in my web project. But, in power BI, in query editor, i don't the syntax how to write.

For example, table1 , table 2 and table3 are in my data set. now i need  3 columns of table 1 and  4 columns of table 2  based on TID.

This is the editor am talking about.

If i want to do the query as below in the above editor. How can i do. If i do, it will result a new table?

SELECT `opportunities`.`id`,`opportunities`.`name`,`documents`.`id` as `doc_id`,`documents`.`document_name`,`documents`.`category_id`,`documents`.`doc_type` ,`document_revisions`.`file_ext`,`document_revisions`.`id` as `revision_id` ,`document_revisions`.`revision` FROM `opportunities`
  INNER JOIN `documents_opportunities` ON `documents_opportunities`.`opportunity_id`=`opportunities`.`id` 
  INNER JOIN `documents` on `documents`.`id` = `documents_opportunities`.`document_id`
  LEFT JOIN `document_revisions` on `document_revisions`.`document_id` = `documents`.`id`
  WHERE  `opportunities`.`name`='".$opportunity_name."' AND (`documents`.`category_id`='SCOPE_DOCUMENT' OR `documents`.`category_id`='PRODUCTION_DRAWING' OR `documents`.`category_id`='WORKS_CONTRACT' OR `documents`.`category_id`='WORKING_DRAWING')  
   AND document_revisions.id = (  SELECT id FROM document_revisions 
              WHERE document_revisions.document_id = documents.id  ORDER BY document_revisions.revision desc LIMIT 1)

Please suggest/help me to understand the query part in Power BI.

Thanks in advance.