Dynamic date in web source

This is Power BI so anything is possible :smileyhappy:

It's a bit hard to read the timeRange value but it looks like 2 dates and times, e.g. Unencoded it would read:

01/01/2016 00:00~04/01/2016 24:00

You'll need to come up with a source for those 2 values.  Is it data driven? A rule based on today? Converted to UTC or a specific timezone? MM/DD/YYYY format or DD/MM/YYYY format?

Once you have that figured out you can Edit the Query and change the generated URI to an expression that contatenates strings e.g.

"https://api.enterprise.apigee.com...timeRange="&[Start Date Time]&"~"&[End Date Time]&"&timeUnit=day"

How you pass them in depends on the source.  If they are pure expressions then you could just embed them.  If they are specific cells in the result of another Query (my preference, for debugging) then you can use a List function to reference them, e.g.

List.First(#"Table1"[Start Date Time])