Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

The official document for this feature don't have this limitation now, so please try it.

 

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

 

Thanks for your response. I had already tried this the only problem is unable to bind the date parameter in the DimDate table.

 

Bind to Parameter doesn't show DynamicDate parameter in the list.

 

it only shows other two text parameters.

Could you please assist.

 

Thanks in advance.