VisionAtlas exposes period-scoped KPI actuals for BI tools and executive reporting pipelines.
Read KPI catalog
GET /api/v1/kpis
Authorization: Bearer va_live_...Returns KPI metadata including externalSource, externalMetricId, validation rules, and current values.
Read KPI actual history
GET /api/v1/kpi-values?since=2026-01-01&limit=500
Authorization: Bearer va_live_...Optional query parameters:
| Parameter | Description |
|---|---|
| `kpiId` | Filter to one KPI |
| `since` | ISO date (`YYYY-MM-DD`) — values with `periodStart` on or after this date |
| `limit` | Max rows (default 200, max 1000) |
Each row includes period boundaries, actual/target, source, and external mapping fields for joins in BI.
Power BI
See docs/analytics/power-bi.md for a step-by-step connection guide using the REST API and recommended star schema.
Semantic model
Entity relationships and grain are documented in docs/analytics/semantic-model.md:
- Grain: one row per KPI per reporting period (
KpiValue) - Dimensions: KPI, Goal (via
GoalKpi), Initiative (viaKpiInitiative), Department, Owner - Facts:
actualValue,targetValue, health derived from direction vs target
OpenAPI
Full request/response schemas: /api/openapi