When we update are sales invoice lines from Exact Online through Invantive to our PowerBI-model, it takes a long time to transfer ±80MB each time.
I read in the Invantive support notes (Snel en met minder API-calls Exact Online uitlezen met de incrementele "sync API"-tabellen) that we should switch to the Exact Online’s incremental tables.
So, we’ve built a new PowerBI model based on the REST-table Incremental.SalesInvoiceLinesIncremental.
Because this table is normalized, we’ve joined it with SalesInvoices.SalesInvoices@eol (for which there is no incremental alternative) and a local ‘Items’-table.
For the moment this also works (and gives the exact powerBI results compared to the non-incremental model), but it still takes 80MB for each update!