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...
amir_mm
2 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.
lbendlin
2 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.