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.
Super UserI think that is it. The query cant be folded completely. My guess is because you added a SQL query and then set the filter using M (power query), that broke the folding.
One thing you can try is to create a view using your SQL query and store in your database, then connect to that query in power bi and add the rangestart and rangeend. And it should look similar to below where you dont have your sql query.
let
Source = Thatviewthatyoucreate,
#"Filtered Rows" = Table.SelectRows(Source, each [ScheduledShip] <= RangeEnd and [ScheduledShip] >= RangeStart)
in
#"Filtered Rows"
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.
- Tutu_in_YYC
But 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!