Historic KPI Data

AMMP's historic KPI data for every tracked site, exactly as AMMP returns it: one row per asset per 15-minute date, AMMP's field names, AMMP's units, and nested data such as tags or data_provider as the JSON AMMP sent. A series' members are columns named by their path, for example pv_power.unit. Every night new readings are pulled from AMMP and the table is rebuilt, and the new copy replaces the old one in a single step, so Power BI never reads a half-built table.

Loading…

What goes in

Every active, tracked site with an AMMP asset. Readings older than the history window are removed.

Request

interval=15m · implicit_weather_correction=false

Fixed, so the table always matches what AMMP returns for this request.

A longer window is backfilled from AMMP on the next nightly sync.

Columns

Tick what Power BI should see and set the order. Names are AMMP's and cannot be changed. asset_id, date and refreshed_at are always included.

Include Field Column name Order
Loading…

Preview

The newest 25 rows, exactly as Power BI reads them.

Loading…