ILAP Analytics API

The ILAP Analytics API lets you consume scheduling data — schedules, activities, periodized progress, resources, links, and metadata — for reporting and integration. This overview is for planners and Power BI / report developers, as well as data engineers, and assumes REST/GraphQL basics and that you can obtain a DataReader token.

What data is available

• Schedules & revisions
• Activities (+ periodized planned/earned/actual hours)
• Successors/links
• Resource assignments
• Calendars
• Metadata fields

Tenant-specific extension fields appear dynamically on GraphQL types and are not enumerated here.

Revision types

• Live — the current working version of the schedule.
• Baseline — the version most recently set as the baseline for comparison.
• OriginalBaseline — the first baseline ever set, preserved for original-plan comparisons.
• Current — the latest revision regardless of baseline status.

REST export vs GraphQL — when to use which

The Parquet export — the third route

REST and GraphQL both serve the data that is currently in ILAP Analytics. Where the export is enabled, ILAP Analytics also writes planning and reporting snapshots as Parquet files into a storage account you own, and those snapshots survive the retention purge that eventually removes the rows from the operational database. Successive snapshots of one report schedule are a record of how the plan moved — which no query against live data can reconstruct.

Use it for historical analysis and for lakehouse consumption; use the API for anything about the present. See Parquet export for the layout and contents, and Reading Parquet from Fabric for consuming it. The export is off by default and enabled per deployment.

Authentication

All API calls require a bearer token scoped to the DataReader role. See the Authentication guide for how to request and use one.

Guides

• GraphQL reference
• Authentication
• Power BI
• Microsoft Fabric
• REST API reference
• Parquet export
• Reading Parquet from Fabric
• Why the export is plain Parquet