Is it possible to setup Incremental Refresh with the Exact Online connector? Currently my customer has two big tables: SalesOrderLines and SalesInvoiceLines. Both are loaded using the respective Bulk endpoint, but it is taking quite some time to complete. It would be best to use the Power BI func…

To limit the amount of API calls on Exact Online, by far the most efficient way for reporting is to follow the instructions in: [billede] Faster Exact Online download using incremental "sync API"-tables Wiki (en) Go to Dutch version The Exact Online REST API provides so-…

Yes, the Invantive UniversalSQL-driver for Exact Online offers *Incremental tables. See: [billede] Faster Exact Online download using incremental "sync API"-tables Wiki (en) Go to Dutch version The Exact Online REST API provides so-called “sync APIs.” Sync APIs are new R…

Thank you! One question, so when using *Incremental tables, the query folding isn’t supported? Let’s say I only want the Sales Invoices and Sales Order from the last three years, what you say that it is best to use the *Bulk endpoint? Is it also possible to use the Power BI Incremental Refresh fun…

Query folding is always supported; it is between PowerBI platform and Invantive Cloud. However, forwarding the filters to the Exact Online APIs is not possible for *Incremental tables, solely for *Bulk. The actual choice depends on a large number of factors. For small environments, the difference …

[billede] forums: The use of Power BI Incremental Refresh is seldom if ever used. Last time checked, it had very limited support for watershed columns. It only supported date/time and not timestamps such as on OData. If we configure the Power BI Incremental Refresh, on tables were date/time c…

This question was automatically closed after at least 1 week of inactivity after a possible solution was provided. The last answer given has been marked as a solution. Please ask a new question via a separate topic if the problem occurs again. Please include a link to this topic in the new question…

Inkrementel opdatering

Spørgsmål (en)

forums 27. November 2024, 13:31 6

To limit the amount of API calls on Exact Online, by far the most efficient way for reporting is to follow the instructions in:

Emne		Svar	Visninger
Onmogelijk om Exact Online tabel (TransactionLinesIncremental) te verversen in Power BI Vragen (alle) exact-online , invantive-bridge-online , invantive-cloud , power-bi	7	25	27. Januar, 2026
Telt elke OData-pagina als Exact API-call, ook bij Incremental? Vragen (alle) exact-online , invantive-cloud	2	20	3. August, 2026
Incremental gegevens laden Exact Online Vragen (alle) exact-online , invantive-data-hub	3	59	28. November, 2024
Power BI refresh loopt vast bij ~10GB Exact Online dataset - limiet bij Exact Online of bij Invantive? Vragen (alle) exact-online , invantive-cloud , power-bi , invantive-bridge-for-power-bi	2	20	4. August, 2026
Large and slow download for SalesInvoiceLinesIncremental Vragen (en) exact-online , performance , invantive-cloud , power-bi	2	108	3. Oktober, 2024

Inkrementel opdatering

Related topics