How to Access Project Online Data After Retirement, Years Later

It's 2029. A compliance officer needs the approved baseline for a project that closed in 2025, three years after Project Online went dark. The migration team that ran the export left the company two years ago. This is the moment that decides whether you can actually access Project Online data after retirement or just point at a folder and hope. What's left is a folder called po_archive_final_v2, sitting on a file share, that nobody has opened since the week it was created.

Nobody in that scenario did anything obviously wrong. The export happened. The data is, technically, all there. The problem is that "the data exists somewhere" and "we can answer this compliance request in an afternoon" are two very different claims, and most PMOs only discover the gap between them when a real audit request lands on a desk with no one left who remembers how the archive was built.

Why "We Exported It" Isn't the Same as "We Can Access It"

Most PMOs treat archiving as a single verb, tucked into the last week of the migration: export the data, check the box, move on to the next task. That framing stops at exactly the point where the real risk begins. An export is a snapshot in a moment; access is the ability to retrieve a specific, correct answer from that snapshot years later, under time pressure, possibly without the person who created it still around to help.

The difference matters because the failure mode is silent until it isn't. A poorly structured archive looks identical to a good one on the day it's created: both are a folder with files in it. The gap only becomes visible when someone tries to actually use it, typically during a real compliance request years after the fact, at which point discovering the archive is unusable is no longer a process fix, it's a data-recovery emergency with no live tenant to fall back on.

Our Project Online archive strategy post covers how to choose an archive approach before the retirement date. This post picks up from the other side: assuming you already archived something, how do you make sure it's actually retrievable when the request comes, and how do you retrieve it when it does.

How to Access Project Online Data After Retirement: What Makes an Archive Queryable

Three properties separate an archive you can use from one you can only look at.

Structure. A raw OData JSON dump or a stack of individually exported .mpp files preserves the data but not a queryable shape. A structured export, flattened into Parquet or CSV with clearly named columns matching the original OData entity sets (Projects, Tasks, Assignments, Baselines, Timesheets), can be loaded into a query tool in minutes instead of requiring someone to write a custom parser first.

Documentation. The archive needs a schema reference: which fields map to which OData entity, what date range each export covers, and which projects are included. Without this, a person years later has to reverse-engineer the structure before they can even start answering the actual question they were asked.

Tested retrieval. An archive nobody has queried since it was created is an assumption, not a capability. Running a practice retrieval, pulling a specific project's baseline and confirming the answer is correct, at least once before you actually need it, is the only way to know the archive works rather than hoping it does.

The diagram below shows the difference between an archive that only has the first property and one that has all three: only the second is actually accessible when a request arrives.

How Do You Read a Cold Project Online OData Snapshot?

If your archive is a raw OData export, someone still needs to parse it before it's usable. The OData snapshot exports as JSON entity collections, one per table (Projects, Tasks, Assignments, and so on), with field names matching PWA's schema exactly.

To make it queryable: load each entity collection into a table in a lightweight database or a data warehouse, using the entity name as the table name and the JSON fields as columns. Preserve the original field names rather than renaming them during load; a future request will be phrased in terms of the field a PM or auditor remembers ("what was BaselineFinish on Baseline 0"), and renamed columns just add a translation step under time pressure. Once loaded, a standard SQL query against the project ID answers most audit requests directly.

If the export predates any structuring effort and exists only as raw .mpp files, OData export is not an option anymore once Project Online is retired; the .mpp files themselves have to be opened individually in a compatible tool, which is exactly the slow, manual process a structured archive exists to avoid. This is the strongest argument for structuring the archive while Project Online is still live, covered in more depth in the OData export guide.

Answering a Compliance Request Without a Live Tenant

A compliance request years after retirement follows a predictable shape, and having a runbook ready turns a scramble into a routine task.

1. Identify the specific ask. Compliance requests are usually narrow: one project's baseline, one resource's timesheet history, one custom field's value on a specific date. Resist the urge to pull everything; a targeted query is faster and less error-prone.
2. Locate the project in the archive index. A documented archive includes an index of which projects, and which date ranges, are covered. Without this, step one turns into a manual search through raw files.
3. Query the structured store directly. If the archive was built correctly, this is a single query against the relevant table, filtered by project ID and date.
4. Cross-reference against a second source if the stakes are high. For a request tied to a legal or financial matter, confirm the archived value against any secondary source that survived migration, such as a PDF snapshot or a report that was generated before retirement.
5. Document the retrieval. Note the archive source, export date, and query used to produce the answer. This becomes the evidence trail if the same request, or a related one, comes up again.
6. Deliver with context, not just a number. A compliance officer needs to know not just what the baseline value was, but how confident you are in the archive's completeness for that project.

Treat this runbook as a living document, not a one-time write-up. Update it the first time you actually use it for a real request, because that's when you'll discover the steps that were harder in practice than they looked on paper.

Why a Folder of .mpp Files Isn't a Real Archive

A stack of individually saved .mpp files feels like due diligence: every project got exported, every file has a sensible name, the folder looks complete. It fails the actual test of an archive for three specific reasons.

First, .mpp files aren't queryable as a set. Answering "which projects had a budget over $500,000" means opening every file individually; there's no way to filter across them without a tool that reads .mpp natively, and that tool may not exist or may not be licensed anymore by the time you need it.

Second, .mpp files don't preserve everything Project Online tracked. Enterprise-level data like resource pool assignments across projects, portfolio-level custom fields, and OData-only computed columns don't round-trip into a single project's .mpp file, so the archive is incomplete in ways that aren't obvious until a specific request exposes the gap.

Third, .mpp is a proprietary binary format tied to Microsoft Project's own version compatibility. An archive built to last five to seven years for compliance purposes is betting on a specific desktop application remaining available and license-current for that entire window, which is a real risk given that Microsoft Project itself is part of the same retirement wave affecting the broader ecosystem.

What Format Survives Best: Parquet, CSV, or a Warehouse?

Format	Queryable without extra tooling	Preserves full schema fidelity	Best fit
Raw .mpp files	No	Partial (project-level only)	Never, as a sole archive strategy
CSV export	Yes, with any spreadsheet or SQL tool	Yes, if schema is documented	Small PMOs, lower compliance bar
Parquet	Yes, with any modern data tool	Yes, with native typing	Mid-size to large PMOs, regulated industries
Data warehouse (loaded from OData)	Yes, natively queryable	Yes, plus supports joins across entities	Enterprise PMOs with existing BI infrastructure

For most enterprise PMOs, Parquet or a warehouse-loaded export both outperform CSV at scale because they preserve field typing (a date stays a date, not a string that needs reparsing) and support the kind of cross-entity joins a real compliance request often needs, such as matching a resource's timesheet history against the project's baseline dates.

Building the Retrieval Runbook Before You Need It

The single highest-leverage thing a PMO can do with an archive is test it before there's a real request riding on it. Schedule one retrieval drill within 30 days of completing the archive:

1. Pick a real, closed project at random.
2. Ask someone who was not involved in building the archive to retrieve its baseline and its final resource assignments, using only the documentation available.
3. Time how long it takes and note every step that required guessing or asking someone else for help.
4. Fix the documentation gaps the drill surfaces, then repeat with a second project to confirm the fix worked.

A drill that takes an afternoon and finds three documentation gaps is a successful investment. A drill you skip because "the export clearly worked" is how PMOs end up needing weeks to answer a request that should have taken an hour, discovering the gap only when the compliance officer is already waiting.

Run the free Project Online Inventory Checklist before your final export to make sure every project, resource pool, and custom field that compliance might eventually ask about is actually captured in the archive, not just the ones that were top of mind during the migration crunch.

Run the free Project Online Inventory Checklist Map every project, resource pool, and custom field in your tenant in about 10 minutes, so nothing that a future audit might need gets left out of the archive. No signup required. → Open the checklist

Microsoft's Project Online lifecycle page confirms the service retires September 30, 2026, with no extended access afterward. Everything in this post assumes the export happened before that date; what happens after Project Online retires covers the mechanics of what becomes unreachable the moment the deadline passes.

Microsoft Project Online™ is a trademark of Microsoft Corporation. Onplana is not affiliated with Microsoft.