Forum Discussion
getting dynamic data based on slicer and getting real time data
Hello Everyone !!
I am a new user of power bi and i wanted to know two things.
1) Is it possible to get data from mysql datasouce in real time based on mysql query.
2) how to dynamically change the mysql query parameter based on slicer.
e.g. if i have a query
select from table name where date = 10/12/2019
than i want to change the date dynamically based on slicer visual say in my slicer i have dates of different months and I select 12/01/2020 from slicer than the above query should act based on 12/01/2020 i.e. select * from table name where date = 12/01/2020
How can i achieve this in power bi?
2 Replies
Anonymous
You can make use of the new feature Dynamic M Query Parameters:https://www.youtube.com/watch?v=hrPbf06aF9o
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
