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.
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… |