Forum Discussion
Dynamic from date and to date in web source query
Replace Source with following where RangeStart and RangeEnd are in parameters
Source = Json.Document(Web.Contents("https://abc.rxyz.io/api/sync/ems/powerbi?date_start="&RangeStart&"date_end="&RangeEnd, [Headers=[Token="7901d444-a86f-4031-8922-7e0222ae"]]))
Vijay_A_Verma , I did create a parameter as suggested from your side.
However, when I look to bind the parameter, i see no option for it.
Kindly guide me with steps to use RangeStart & RangeEnd as parameters.
You need not bind just put the dates such as 2022-07-01 in these parameters. Make sure that you select Text as type for parameter value not as date.
I do not wish to hard code the start & end date. I need it to change based on user selection. Hence trying to bind
What will be the source of your start and end dates?