Forum Discussion
How to pass dynamic date parameter to SQL query through slicer or any alternate solution
Hello Team, There is a requirement of passing a date picker parameter to the report dataset to fetch only the data for that specific date(Single datepicker). The data is more than 3Million rows ...
You can setup a dynamic parameter, please see the below tutorial.
Setup Dynamic Parameters to Filter data in your PowerBI Report | MiTutorials - YouTube
miTutorials Thanks so much for your response. In the video the date parameters are selected before loading the resport. However the requirement is to select the single date slicer from home page and then on button click fetch the data only for that selected date.
Data source SQL Query date parameters needs to be pass through about date slicer.