Forum Discussion
mehaboob557
Resolver III
Resolver IIIHow 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...
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
mehaboob557Resolver III
Resolver IIIHi 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
Community Support
Community SupportHi mehaboob557,
Power BI provide Query Parameter feature, which can be used to filter data already retrieved in Query Editor. But this query parameter can't be passed to MySQL query. For more information, see:
Deep Dive into Query Parameters and Power BI Templates
Power BI Desktop Query Parameters, Part 1
Best Regards,
QiuyunYu