Audit Cell History in Fabric Plan shows who changed a planning cell, what changed, and when, and lets you undo any user’s change by restoring an earlier value. It is available now with the Native Planning Engine, in Public Preview.
Point-in-Time Restore
Return any selected cell to a value recorded by any user at any point in its available history.
Choose an entry from the cell’s timeline and restore that exact value. The restoration is captured as a new auditable change, so recovery does not break the history.
Key Capabilities
- Point-in-time recovery: Restore the exact value from any selected entry in the cell’s recorded history.
- Complete value timeline: Follow every recorded change for the selected leaf-level cell in sequence.
- Clear attribution: See the action, old and new value (What), user (Who), and timestamp (When) for each change.
- Flexible filtering: Narrow the history by Changed By, Actions, or Time Period.
Important compatibility note: Cell History is available only with the Native Planning Engine. It relies on the engine’s file-based architecture in OneLake and is not supported by the previous planning engine.
Cell-Level Context with Point-in-Time Recovery
Fabric Plan already provides a detailed audit experience. The Data Input tab captures sheet-wide data activity: tag, action, row, column, old value, new value, user, and timestamp. The Reports tab captures report changes such as scaling, columns, and formatting.
Cell History complements those broad views with a focused, actionable timeline for the value a planner has selected. The row, measure, period, user, action, and value transitions are presented together, directly beside the planning grid. A planner can then select any recorded entry and restore that exact value to the cell.
Select the January Quantity Forecast for Canada › Home › Essential (6.30M) and open its complete change story in context.

Two Views for Two Different Tasks
Report Audit explains how the report changed. Cell History explains, and can restore, one planning value.

How Fabric Plan Cell History Works
Cell History is available for a leaf-level data-input cell. Select a specific intersection of business context and time, such as Canada, Home, Essential, January 2026, Quantity Forecast, and open Cell History. The side panel keeps that complete coordinate visible while it lists the recorded changes from newest to oldest.
Canada › Home › Essential › 2026 › January › Quantity Forecast
Example Change Sequence

Each entry identifies the mechanism that produced the change. A leaf value may have changed through direct input, an allocation from a parent, a bulk update, or pasted values. Cell History keeps those actions distinct.
Recorded Change Types
| Change type | What it means |
|---|---|
| Initial Value | The earliest recorded state of the cell, before any tracked change. |
| Allocation | A value entered at a parent or subtotal was distributed down to this leaf cell. |
| Manual Input | A planner directly edited this leaf-level value in the grid. |
| Bulk Edit | The cell changed as part of a multi-cell update configured through Bulk Edit. |
| Copy Paste | The value was pasted from another grid range or from outside the planning experience. |
| Delete | The planned value was removed, leaving the leaf cell blank until another action supplied a value. |
| Restored | A user intentionally returned the cell to one of its recorded historical values. |
| Reset | The cell returned to its configured default, or to blank when no default exists. |
Filter by User, Action, or Time Period
A cell can accumulate many changes. The filter panel narrows the list while the selected cell remains fixed.
- Changed By: Choose users
- Actions: Choose change types
- Time Period: Select a date range
Example Filters
Show only allocations made by a specific user, isolate deleted values or manual inputs, or limit the list to a selected date range.
Restore Any Recorded Value from Any Point in Time
Use Changed By, Actions, or Time Period to locate the exact entry. Select it and choose Restore to return the leaf cell to that recorded value, regardless of which user originally made the change. The restoration is recorded as another change in the cell history.
| Action | What it does |
|---|---|
| Restore | Return the selected cell to a specific value from any point in its available history. |
| Delete | Remove the current planned value. Cell History records the old value changing to blank as a Delete action. |
| Reset | Remove the current planned input and return the cell to its configured default. If the default is blank, the cell returns to blank. |
Using Cell History
- Select a leaf-level input cell. Choose the exact row, measure, and period whose value needs explanation.
- Open Cell History. The side panel is automatically scoped to that data point and displays the number of recorded changes.
- Read the timeline. Review the old and new values, action type, user, and timestamp for each change.
- Filter when necessary. Narrow the timeline by Changed By, Actions, or Time Period.
- Restore the selected point in time. Return the cell to that exact historical value; the restoration is added to the audit trail.
- Reset when needed. Return the cell to its configured default or blank state.
How Cell History Fits with Audit
The two experiences are complementary. Audit is designed for broad review and export, while Cell History is designed for focused investigation and recovery at the selected leaf-level cell.
Audit vs. Cell History
| Capability | Audit | Cell History |
|---|---|---|
| Scope | Entire report history across data-input and report-configuration activity | One selected leaf-level cell |
| Change context | Report-wide records for review and governance | Who changed it, What changed, and When |
| Undo and Restore | Not supported | Undo a specific change by restoring its selected historical value |
| Export | Export the entire report history to Excel | Cell-level history export is not supported |


Practical Result
Cell History turns audit information into a recovery workflow. A planner can see whether a value came from a direct edit, allocation, bulk update, paste, or deletion; identify the user and time; and restore the exact recorded value from any selected point in the cell’s available history.
The feature is intentionally narrow: it applies to a selected leaf-level input cell. Sheet-wide data changes remain in Data Input audit, and report configuration changes remain in Reports audit.
Related Resources
- The Native Planning Engine Is Here as Public Preview: turn on the engine that Cell History requires.
- Security and Audit in Fabric Planning (video): the sheet-wide audit and access controls that Cell History complements.
- Approvals and Workflows in Fabric Plan: add review and sign-off on top of change tracking.
- Allocation rules and data input controls: how the Allocation and Reset entries in Cell History are produced.
- What is plan in Fabric IQ? (Microsoft Learn)
Feature details reflect Fabric Plan at the time of writing.


Comments
0Please log in to comment.