Forum Discussion
amir_mm
2 years agoHelper III
Incremental refresh - Table keeps loading in PBI desktop
Hello, I defined new parameters on a date/time column in one of the tables (RangeStart and RangeEnd), and filtered the column to a custom date range, but when loading into PBI desktop the table k...
lbendlin
2 years agoSuper User
Aren't these a little too small for the effort you put into Incremental Refresh? How long does a regular load take?
- amir_mm2 years agoHelper III
After I defined the RangeStart and RangeEnd on both tables, it takes 2-3 min to load.
The main issue is auto refreshing, as we face memory capacity limit (we are on premium A2), so I thought maybe I can do some partitioning and refresh each partition separately.
- lbendlin2 years agoSuper User
fair enough. Usually you start thinking of incremental refresh when you are north of 200 Million rows, or getting close to the 5 hr hard limit.