Microsoft Fabric Plan: Native Enterprise Planning and AI Forecasting in OneLake

Summary

With the introduction of “Planning in Microsoft Fabric” in Public Preview, Microsoft addresses a critical gap in its SaaS data platform. Co-engineered with Lumel, this solution integrates budgeting, simulations, operational data entry, and AI-driven forecasting directly into the Fabric ecosystem. By connecting natively to Power BI semantic models and providing real-time write-back to OneLake, it eliminates risky data exports and spreadsheet silos, posing a significant challenge to traditional Enterprise Performance Management (EPM) platforms.

What happened?

Microsoft has launched the Public Preview of “Planning in Microsoft Fabric” (commonly known as “Fabric Plan”), targeting General Availability (GA) in Q3 2026. The platform centers around three core modules:

Planning Sheets: A user-friendly interface built on top of Power BI semantic models that supports budgeting and write-back directly to Fabric SQL in real-time.
PowerTable Sheets: A no-code, Excel-like interface tailored for master data management and structural dimension editing.
Intelligence Sheets / Predict: An AI-powered engine that analyzes historical data to generate multi-seasonal forecasts with customizable confidence ranges in seconds.

The B2B ecosystem has reacted quickly. German BI specialist Bissantz announced consulting services and an upcoming webinar on July 16, 2026, focusing on integrating DeltaMaster analytics tools with Fabric’s planning engine. Microsoft also announced a hybrid billing model combining role-based and job-based pricing to help companies manage costs during high-intensity planning cycles.

Why it matters

Hosting planning and forecasting natively within the primary data platform offers substantial advantages:

Eradication of Data Silos: Financial budgeting and actuals reporting operate on the same governed data layer (Single Source of Truth), removing the need for exporting data.
Real-Time Collaboration: Multi-user concurrent editing and immediate database write-back drastically accelerate financial planning workflows.
Enterprise Governance: Planning worksheets automatically inherit Fabric’s native security, compliance, and OneLake governance settings.
Cost Flexibility: The new hybrid pricing model lowers entry barriers compared to rigid, seat-based legacy EPM licensing models.

Evidence

Official Roadmap: Microsoft has made the preview public and targeted Q3 2026 for General Availability.
Documentation Portals: Official setup guides are active at learn.microsoft.com/en-us/fabric/iq/plan/overview and docs.fabricplan.com.
B2B Partnership Activity: Immediate commercial support from Lumel (co-engineer) and Bissantz (integrated webinars) validates the direct business relevance of the preview.

Analysis

The launch of Fabric Plan represents a major strategic shift. Until now, Microsoft Fabric was primarily a platform for data ingestion, warehousing, and analytics. For corporate planning, budgeting, and forecasting, finance departments still relied heavily on standalone spreadsheets or legacy EPM software.

By embedding planning directly into OneLake, Microsoft removes the friction of moving data between systems. Since companies are already housing their data lakehouses and reports in Fabric, extending that footprint to budgeting is a logical step. The Excel-like UX design of Planning Sheets makes it easy for controllers to adapt, while the “Predict” feature demonstrates how predictive AI can be embedded into everyday analytical workflows.

Practical Takeaways

Evaluate Software Costs: Finance leaders should review their current EPM software subscriptions against Fabric Planning’s flexible role-based pricing.
Assess F-SKU Capacity: Because planning involves frequent write-backs, ensure your organization’s Fabric capacity (F-SKU) is scaled appropriately to prevent latency during planning seasons.
Leverage Partner Demos: Controlling teams should participate in partner-led webinars (such as Bissantz) to explore how existing analytical toolsets integrate with the Fabric Plan engine.

Open Questions

Scalability Under Peak Load: How well does the real-time write-back perform when hundreds of users submit budget adjustments concurrently?
F-SKU Requirements: What is the minimum Fabric capacity tier required to run the “Predict” forecasting models smoothly?
ERP Integration: How easily can existing financial ERPs and consolidation engines sync back with the new Fabric-native write-back structure?