Dataflow not saving my rangestart and rangeEnd paramters and keep defaulting to Year 9999

[Anonymous]

Hello guys, 

So i am trying to add incremental refreshing and two parameters, rangestart, rangeend appeared, in my main query: 

#"Main-44617465-autogenerated_for_incremental_refresh" = Table.SelectRows(AddDate, each DateTime.From([Date]) >= RangeStart and DateTime.From([Date]) < RangeEnd)

My RangeEnd: -> which will give me 11/20/2019, 15:30:00 pm the current time 

let

  RangeEnd = DateTime.FixedLocalNow()

     meta [IsParameterQuery=true, List={}, Type="DateTime", IsParameterQueryRequired=true,  

     Description="autogenerated_for_incremental_refresh"]

in

  RangeEnd

However, whenever I save and exit en re-enter into my entity, it does not save my RangeStart and RangeEnd variable/ parameters

it default back to 

let

RangeEnd = #datetime(9999,12,31,23,59,59) meta [IsParameterQuery=true, List={}, Type="DateTime", IsParameterQueryRequired=true, Description="autogenerated_for_incremental_refresh"]

in

RangeEnd

why is this the case? 

 I am really not sure why it is not saving my input, i tried refreshing the browser, closing and re-opening, etc. 

Anyone got a hint? 

btw, this is my incremental refresh 

and this is how my main query look like, line 13,  the main-44617465 step is automatically added once i set up the incrementa refreshl setting and i am just trying to change rangestart rangeend to my customized value. 

[v-lili6-msft]

hi @Anonymous 

If you could try this code directly

let

  Source = DateTime.FixedLocalNow()

in

  Source

Regards,

Lin