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 function of incremental refresh, that we will only daily refresh the mutations which have occurred in the last 7 days,
This would optimize the query, and the load time.
Yes, the Invantive UniversalSQL-driver for Exact Online offers *Incremental tables. See:
However, when not the full dataset is needed, but a sliding window in time, it is recommended to use *Bulk with a filter step as described in What is PowerBI's query folding? Why does it enhance performance?.
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 function with any of the tables:
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 can be small, but for environment with millions or tens of millions of lines it is harder to provide a generic recommendation.
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 columns are available than it will work?
We have different Power BI models which are refreshed daily, and I try to adjust them to keep the amount of lines and API calls as low as possible.
Do you have alternative tips to limit the amount of API calls?
To limit the amount of API calls on Exact Online, by far the most efficient way for reporting is to follow the instructions in:
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 by pasting its URL into the text.
Dit topic is 3 dagen na het laatste antwoord automatisch gesloten. Nieuwe antwoorden zijn niet meer toegestaan.