Forum Discussion
Incremental Refresh - Not retaining old records
I had to convert the date field to a date/time. It now looks like this "06/16/22 12:00:00 AM". I changed the parameters to match the date/time format and now it lets me set up the incremental update without the folding error. I will be testing it this evening when the new data comes in and will report back.
I created a view and added the filter.
let
Source = Sql.Database("devtest\ittestsql1", "awcmdb"),
dbo_MTSBackorders_VW1 = Source{[Schema="dbo",Item="MTSBackorders_VW1"]}[Data],
#"Filtered Rows" = Table.SelectRows(dbo_MTSBackorders_VW1, each [ScheduledShip] <= RangeEnd and [ScheduledShip] >= RangeStart)
in
#"Filtered Rows"
It no longer shows the folding message but now it doesn't see the filter set up with the parameters.
Super UserBut the parameters are set up right? With correct data type?
I had to convert the date field to a date/time. It now looks like this "06/16/22 12:00:00 AM". I changed the parameters to match the date/time format and now it lets me set up the incremental update without the folding error. I will be testing it this evening when the new data comes in and will report back.
- Tutu_in_YYC
Lets hope it works!