Forum Discussion

amir_mm's avatar
amir_mm
Icon for Helper III rankHelper III
2 years ago

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...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Aren't these a little too small for the effort you put into Incremental Refresh? How long does a regular load take?

amir_mm's avatar
amir_mm
Icon for Helper III rankHelper III
2 years ago

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's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    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.