making sql query dynamic based on slicer date

0
votes

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

1
powerbipowerbi-desktoppowerbi-datasource
Power BI will do that for you. Change your query to select * from table name only and add a slicer for date field. – Andrey Nikolov
Actually my scenerio is very complex and i have to follow the requriement defined above. I wrote the above query simple so that reader can understand my requirement. – Faizan Gauhar
Then your simple example has nothing in common with the real complex requirement. To get any meaningful assistance, you should read How do I ask a good question? and How to create a Minimal, Reproducible Example and then update your question. – Andrey Nikolov

1 Answers

0
votes

What you are looking for is called Direct Query, but that's not supported for MySQL data sources. (Datasource supported feature list)

You might be able to do some tricks on PowerBI Desktop using templates and ask for parameters first, then run a query. But that's not the proper usage of the functionality and you won't be able to use it anyway in the PowerBI Service (since you can't deploy a template). This also tends to be tricky and requires a good amount of manual work in M language (Power Query)

Summarizing, for your case I think the answer is no.