How to take date as a user input and run the query according to it?

[mahmoud_kfawzy]

I have a live oracle DB connected to Power Bi refreching every hour always showing the stats of today:

Query goes something like that

"where date >= sysdate"

Now I want to be able to show specefic dates in the past.

How I do it right now:

* Remove the where clause and select all dates in the query

* Show a slicer with every date there is and let the user choose it and dsiplay it

(This methid is very slow and takes a lot of time to load with "select *")

Is there a methid where user enters for example "2021-12-28", and then it'd automatically query:

"where date == '2021-12-28'"

And load this specefic date?

Thank you.

[AllisonKennedy]

@mahmoud_kfawzy  this might help: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters