Forum Discussion
Inject choosen date into an API
Hi Pigsfoot ,
I think in import mode such scenario is not possible to implement. For Direct query mode this is possible.
You can change parameter value in power bi desktop using edit parameter option or in power bi service setting option for import query mode.
If you interested to use edit parameter for import query option, then in power query create parameter and replace hardcoded date with the parameter.
First create a date query using list.date funtion. Chk image:
Then Create parameter, for my case startdate. Check image:
For your case you need to convert date to Epoch Format.
Replace hard code date with the parameter. Check image:
Close and load. In power Bi Desktop, change date through edit parameter option. Check image:
Select any date you want your souce to update. Check image:
Similarly, in power bi service through setting option:
Go to parameter to change value:
Hope this helps!!
If this solved your problem, please accept it as a solution!!
Best Regards,
Shahariar Hafiz