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 ,

 

I want to know, is there dynamic variable can be passed into query using Power Bi. I mean, if i am selecting any value.. that value to be passed into the query which gives a result in the visualization... is this possible ?

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

Hi mehaboob557,

 

Do you have any other questions? If you are satisfied with my response, would you please mark a helpful reply as an answer so we can close the thread?

 

Best Regards,
QiuyunYu