Forum Discussion

mehaboob557's avatar
mehaboob557
Icon for Resolver III rankResolver III
9 years ago
Solved

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

Hello All,   I am a very new bie to Power BI. Exploring so many about Power BI to use. I am successfully connecting to mysql db and i can fecth tables which is need and i manged the relationship be...
Need Help
Show and Tell
Tutorial Requests
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi mehaboob557,

     

    You can click Get Data -> MySQL database, then paste the query in the red section below then click OK. It will create a new table.

     

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

Hi mehaboob557,

 

Please make sure the query can run successfully in MySQL workbench firstly then paste the query into below red section:

 

w1.PNG

 

Best Regards,
Qiuyun Yu

aneeshvarghese's avatar
aneeshvarghese
Frequent Visitor
8 years ago

Hi i totally understand how to fetch queries from Mysql. My question is about schedule refresh and creating a live connection in power BI web. How do we do that??