The incremental load of Exact Online Sync API tables can take very long and even multiple days.
Even worse, when for instance PowerBI.com is used to download the initial set, the not always reliable nature of PowerBI downloads can cause excessive API use.
Most tables use the HTTP disk cache and/or response cache as restart capabilities to reduce the impact of fluctuating reliability on total execution time. However, incremental tables don’t do so. They start every time again at the first page of data.
Idea is to improve restart capabilities of Exact Online Sync API-based tables by using HTTP disk cache or another mechanism such that even day-spanning downloads can be finished.