Improve performance of loading Exact Online data into Power BI

Questions
,
2

Is it possible to add the approximate number of rows to each table and the approximate duration in seconds?

10 minutes for one or a few companies for these is long. I would recommend the following changes:

  • Replace GLAccounts by either GLAccountsIncremental or optionally GLAccountsBulk.
  • Do not use ReportingBalance but replace it by the much faster BalanceLinesPerPeriod (when not using cost centers nor cost units) or BalanceLinesPerPeriodCostAnalysis (when needing numbers per cost center and/or cost unit).

Also, GLClassifications has been changed by Exact Online to include very many mappings (this change may have been reverted in between time). Please refer to Efficient werken met GLClassifications voor rapportages over veel Exact Online administraties, but since that one is in Dutch a summary:

  • Replace GLClassifications by GLClassificationsBulk (10x faster).
  • Or filter out the “Referentie GrootboekSchema” entries, which are over 10.000 lines you are probably never using per Exact Online company. Do not use GLClassificationsBulk in that case and stick to GLClassifications , but add a Power BI filter step SourceDivision is not null` directly after data retrieval (300x faster thanks to PowerBI’s query folding).