
Microsoft Fabric Plan is now generally available. Here’s what that means for organizations still
reconciling budgets, forecasts, and actuals across multiple platforms.
Ask any FP&A team how long their monthly close cycle takes. Then ask them how much of that
time is spent moving numbers between systems: exporting actuals from the data warehouse,
copying them into the planning tool, reformatting them for BI reports, and reconciling
discrepancies when the versions do not match. The answer is often: most of it.
Microsoft Fabric Plan, now generally available, is designed to bring planning, forecasting,
reporting, and data management together on a single platform using the same semantic model
that supports business reporting. With a shared semantic model, organizations can now keep
planning and reporting aligned without ETL between planning and reporting layers or
synchronization delays.
Fabric Plan is available through an eligible Microsoft Fabric capacity subscription, with no
separate per-user license. Each user session can include Planning, Intelligence (reporting), and
Data Management (PowerTable).

What the platform delivers?
Fabric Plan is not a single feature; it combines three capabilities that traditionally required multiple products. Together, they create a connected planning environment instead of separate planning, reporting, and operational workflows.
Capability 01
- Enterprise Planning
Build budgets, forecasts, and scenarios with writeback directly in Fabric SQL using the existing semantic model instead of a separate copy. It supports top-down and bottom-up planning, rolling forecasts, statistical forecasting, driver-based models, and multidimensional cube planning while maintaining alignment with enterprise data.
Capability 02
- PowerTable (Data Management)
Create no-code applications for reference data, multilevel approval workflows, form-based data collection, project and time tracking, and event-driven automations, all governed by row-level access controls and a complete audit log.
Capability 03
- Integrated Intelligence
Access a library of more than 100 charts, KPI cards, variance matrices, and board-ready financial statements built on live Fabric data, with calculated rows, financial templates, and pixel-perfect Excel and PDF exports that preserve the underlying P&L hierarchy.
How Microsoft Fabric Plan Enables Comprehensive Enterprise Planning
The depth of Fabric Plan becomes clearer when you look at the planning scenarios it supports natively scenarios that many enterprise planning tools either do not support or require costly configuration to enable.
- Top-down and bottom-up planning in the same plan.
Finance sets a company-wide target and distributes it using prior-year weights. Sales managers then make bottom-up adjustments at the brand and segment levels. The Optimizer can take a gross profit target and calculate the combination of revenue growth and cost reduction required to achieve it, a capability that has historically required a custom Excel model or a separate optimization tool.
- Rolling forecasts that actually roll.
As each month closes, teams can replace forecast values with actuals and extend the planning horizon to the next period. The statistical forecasting engine which supports Trend Decomposition with MSTL, Exponential Smoothing, and ARIMA, generates a forecast from historical data, with a configurable confidence interval and growth factor layered on top. When assumptions change, Reforecast updates the distribution across all open periods in one action.
- Multidimensional planning without re-entry.
Finance plans revenue at the region and country levels, while the cost team plans by category and brand. Cube measures allow both plans to be entered once at their natural levels and then resolved automatically across the full four-dimensional grain in a shared profitability view. Two way synchronization ensures that a revision in either sheet is reflected everywhere immediately.
- P&L hierarchies that cascade in real time.
Measure Model organizes existing semantic-model measures such as sales volume, average selling price, raw-material cost, and labor into a structured P&L hierarchy. When a planner asks what happens to net profit if raw-material costs increase by 8% in Germany, the impact is visible in real time across every node, without changing the underlying plan.
- Board-ready reporting without leaving the platform.
Until now, producing a formatted P&L with custom margin rows, a manually entered shares outstanding figure, and earnings per share calculated on the fly, often meant exporting to Excel and rebuilding the report by hand each period. Fabric Plan’s Intelligence layer builds the statement directly on the semantic model. Teams can apply a financial template for automatic indentation and subtotals, insert calculated and static input rows that do not exist in the model, group or hide confidential lines, tag the controller in an in-context comment, and export the result to Excel with the hierarchy intact or to PDF for the board pack. The finance team gets the report it needs without rebuilding it in a spreadsheet.
A Security Model Built for Enterprise Governance
Fabric Plan inherits security rather than requiring teams to rebuild it. Row-level security defined on the semantic model flows through workspace roles to app-level controls. Stakeholders, typically users who need to enter data and approve changes but do not author reports, can participate in planning once the required DMTS connection is configured. Data input, scenarios, comments, and writeback permissions can each be restricted independently. Every cell-level change is captured in the audit log and can be filtered by user, date, and measure.
The Capacity Model, in Practical Terms
One eligible Fabric capacity subscription covers all three modules—Planning, Intelligence, and PowerTable—for authorized users. Consumption is measured in Compute Unit Hours (CU-Hours) for each 30-day session: 847 CU-Hours for a Planner (author and modeler), 168 CU-Hours for a Stakeholder (data entry and approvals), and 37 CU-Hours for a Viewer (read-only). Organizations using an F SKU or Power BI Premium P1 and above are supported, while Power BI Pro and Premium Per User are not supported for Fabric Plan scenarios that use XMLA endpoints and embed tokens.

30-Day Session
30-day session
30-day session
How iLink Digital supports Fabric Plan adoption?
iLink Digital is a Microsoft Solutions Partner with delivery experience across the Microsoft Fabric platform, including data engineering, analytics modernization, semantic-model architecture, and Power BI. As a trusted Microsoft Fabric featured partner, we have supported customers throughout their Fabric adoption journeys and have been preparing for Fabric Plan since its preview. Our Data & AI practice combines deep technical expertise with functional knowledge of planning use cases that matter to CFO and COO organizations, as well as business units beyond traditional IT. These include demand forecasting, capacity planning, FP&A cycles, sales quota and territory planning, and headcount and workforce modeling. We help customers assess their current planning landscape, identify where Fabric Plan fits within existing Fabric investments, and design an implementation roadmap that delivers value quickly, whether starting with a single business unit or scaling to an enterprise-wide rollout.
That is exactly where iLink Digital can help.
Ready to assess Fabric Plan for your organization?
Our Data & AI team can map your current planning environment to Fabric Plan’s capabilities and outline a practical implementation path. No commitment required


