Forum Discussion
SAP odata incremental load concept
hi all,
Looking for good ways to do incremental loads from a SAP based odata feed. Am already considering the option of using a datetime stamp but I was wondering if odata also better ways to do this, as it looks like it also is able to feed inserts/updates/deletes (CDC concept).
Would anyone have any ideas/experience that you could share?
Thank you
Bart
1 Reply
Hi BartVW,
For Power BI, the usual approach is incremental refresh using RangeStart and RangeEnd against a stable date field. A separate last-modified timestamp can optionally be used with Detect data changes.
Make sure the date filter is pushed to the SAP OData service. Otherwise, Power BI may still retrieve the full dataset and filter it locally.
OData delta tracking can represent inserts, updates, and deletes, but Power BI incremental refresh does not automatically consume delta tokens. Hard deletes also require a soft-delete flag or another separate process.
You may also evaluate Power BI Connector for SAP:
It provides an OData endpoint and supports Power BI incremental refresh for SAP data.
A 30-day free trial is available.
Documentation:
https://metricasoftware.com/docs/sap/Cheers,
Metrica Team
