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 ,

 

Thanks for your response.

 

I had already went through this link however there are limitation for Direct Query for SQL Server Datasource. Please check below snippet due to which the power bi doesn't show bind to parameter property in Advance section. 😞

Link for the reference.

Bind to parameter not showing in Modeling tab if w... - Microsoft Fabric Community

 

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.