use current date in current value of manage parameter

[Umair_Aslam01]

Hi everyone!

I am trying to use date parameters in the Power BI direct query but I am facing a problem. Can anyone help me to overcome it?

It is about the use of the current date in the current value of the manage parameter.

I am binding the date with the date parameter but it want one value that is used on the first time loading of the report. I want to use current date in the current value tha first time it should run current date automatically.

Can anyone help me.

Thanks.

[v-stephen-msft · Accepted solution]

Hi @Umair_Aslam01 ,

Current Value in parameter management cannot be set dynamically.

If you want to filter data before loading dynamically, please refer to the following way:

Solved: Dynamic Date Parameter for Import Queries - Microsoft Fabric Community

You do this by creating a query in Power Query and referencing that query when you type SQL Statement into the connector.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[ppm1]

Are you doing import or direct query? In any case, you wouldn't use a parameter for that. Either use the pulldown on your date column and choose one of the date filters there (e.g., is in previous 1 day), or use Date.From(DateTime.LocalNow()) to get today's date dynamically in the formula bar.

Pat

[Umair_Aslam01]

I am using direct query and binding the parameter with the date column and the parameter wants the initial (default) value. I want to you their current date.

I am trying to use if condition in advance query but not get sucess yet.