SAP B1 → Power BI / Tableau Incremental Feed

Read-only, scheduled incremental extract from SAP Business One for BI tools. Pulls documents changed since the last high-water mark using an OData UpdateDate filter, filters out cancelled/void rows, normalizes multi-currency totals, and pushes a clean dataset to the BI push endpoint — never writing back to B1.

Steps in this flow

  1. Schedule: Incremental Refresh
  2. Read Last UpdateDate Watermark
  3. SL Login (read login, 401→relogin)
  4. SL: GET /Invoices (incremental, no cancelled)
  5. Normalize Multi-Currency + Shape
  6. Push Dataset → BI Endpoint
  7. Persist New Watermark (after successful load)
  8. Log Rows Pushed

All templates