For guidance, it is recommended to read the following:
- What are the critical points for implementing Power BI?
- Faster Exact Online download using incremental "sync API"-tables
- SQL-stuurprogramma voor Exact Online API - Exact Online API Data Model
For reporting purposes, in general it is recommended to use the *Incremental tables.