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

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

Hi v-qiuyu-msft,

 

Thank you so much. I will try and i will accept the solution once it works for me :)

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

Hi v-qiuyu-msft

 

Please help in query part. As suggested by you, i did.

 

But,  OldGuids=true error is coming while i am writing query directly.

  • 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??