FABRIC PLAN: HOW-TO GUIDES

Plan Directly on Your Semantic Models on Microsoft Fabric

Your semantic models already encode your business logic, hierarchies, and measures. Lumel plans directly on top of them. Your first plan goes live in minutes, not months.

Featured Video

▶
4:58

Intelligence 300 - Intelligence Sheet Interface Overview

Intelligence

Learn how to work with Intelligence Sheet in Microsoft Fabric Plan. Explore the report layout, customize visuals, manage themes and interactions, configure comments and security, and switch seamlessly between editing and reading modes to build interactive reports.

Featured Video

▶
6:47

PowerTable - Getting started with a CSV/ Excel File

PowerTable

See how Microsoft Fabric simplifies Master Data Management with PowerTable in Microsoft Fabric Planning. Import data from CSV or Excel, configure approvals and workflows, apply formulas and conditional formatting, manage data quality, and collaborate with built-in governance all within a connected, no-code data management experience.

Featured Video

▶
5:40

PowerTable Introduction & Walkthrough

PowerTable

Explore the PowerTable interface and learn how to create and manage no-code data apps, configure approvals and workflows, automate business processes, apply access controls, collaborate with comments and bookmarks, and manage enterprise data in a unified experience.

Featured Video

▶
47:07

Build a P&L Forecast in Microsoft Fabric

Planning

See how Microsoft Fabric simplifies P&L forecasting with connected planning. Create budgets and forecasts from historical data, simulate scenarios, collaborate across teams, and manage allocations with a code-free planning experience.

Featured Video

▶
01:07:39

Multi-Dimensional CUBE for Planning and Allocations

Planning

Master multidimensional planning and allocation in Microsoft Fabric with this hands-on session on Fabric Plan Cube, where real-world use cases like expense allocation, chart of accounts allocation, forecast allocation, and gross margin calculation are demonstrated using Cube in Fabric Plan. Learn how to build multidimensional planning models, handle related and unrelated dimensions without coding, perform bidirectional allocations, allocate OPEX across products and channels, create gross margin calculations using reference measures, and connect Power BI semantic models to Fabric Plan. This session also covers practical implementation steps including setup connections, planning sheets, allocation logic, and spread/distribution techniques for enterprise FP&A and planning workflows.

Featured Video

▶
5:35

Microsoft FabCon Keynote (Amir Netz, CTO of Microsoft Fabric)

Planning

What if your data platform could not only analyze the past but also plan the future? In this session, we introduce Planning in Microsoft Fabric—a powerful new workload that brings end-to-end enterprise planning directly into the Fabric ecosystem. Fully integrated with OneLake, Power BI, and Fabric IQ, this capability enables teams to build revenue plans, run scenario analysis, collaborate in real time, and write back plans seamlessly to the data layer. With built-in security, auditability, and no per-seat licensing, Planning in Fabric transforms how organizations forecast, experiment, and align on business goals—unlocking a new level of intelligence for AI-driven decision-making.

Featured Video

▶
1:37

Fabric for the AI Era - FabCon (Satya Nadella, Chairman and CEO at Microsoft)

Planning

AI innovation is accelerating, and intelligent agents are becoming embedded in everyday workflows—from command lines to team collaboration. In this keynote, discover how Microsoft Fabric is powering this shift with a unified data estate that brings together operational, real-time, and analytical data. Learn how Fabric enables better context engineering for agents to reason, act, and deliver real business value. Explore the latest advancements, including the Database Hub, Fabric IQ with business-ready ontology models, expanded data integration capabilities, and new planning workloads for enterprise performance management. Get a preview of what’s next for data and operations agents as Fabric continues to evolve as a complete data platform for the AI era.

Featured Video

▶
1:51:54

Writeback with Fabric Planning: How to Get Started

Planning

Writeback - one of the most requested capabilities in the Power BI community—is now native in Microsoft Fabric with the introduction of Fabric Plan Item in Fabric IQ. In this session, Gopal Krishnamurthy and Reid Havens walk through how native writeback works in Fabric Planning—from building planning apps on semantic models and enabling stakeholder collaboration, to writing inputs back into Fabric SQL and governing data with PowerTable’s live writeback. They also cover variance commentary and intelligent writeback using Intelligence Sheets, making this a must-watch for FP&A, operations teams, and BI developers looking to move beyond spreadsheets and build enterprise-grade planning solutions directly in Fabric.

Featured Video

▶
1:14:41

Fabric Planning: What, So What, and Now What?

Planning

Discover how Microsoft Fabric Planning is revolutionizing Enterprise Performance Management within the Power BI ecosystem. This session explores native write-back capabilities, multi-dimensional forecasting, and seamless master data management-empowering FP&A teams to transition from disconnected spreadsheets to a unified, secure data platform.

Featured Video

▶
6:25

Microsoft Fabric Planning Onboarding - Access and Setup

Planning

Learn how to set up and configure Fabric Planning from start to finish in this step-by-step tutorial. This video covers tenant settings, semantic model connections, RLS behavior, SQL connections, viewer access, and optional writeback configuration in Microsoft Fabric Planning. Discover how to enable collaboration, manage permissions, and ensure seamless planning workflows for your organization.

Planning

2. Creating your first planning app

2.1. Create a Plan app and connect to a semantic model
2.2. Build your first Planning sheet
2.3. Explore the interface
2.4. Basic interactions
2.5. Create a Forecast
2.6. Write back and save your data

Read more →
Planning

3. Entering plans and budgets

3.1. Data input basics
3.2. Plans calculated using formula columns
3.3. Incremental and zero-based budgeting using number columns
3.4. Row-level comments using text columns
3.5. Budget approval status using an inserted list column
3.6. Checkbox columns to show final approval
3.7. Approver column by inserting names
3.8. Approval deadlines using a date column
3.9. Inserting audit logs
3.10. Summary: When to use what

Read more →
Planning

4. Top-down allocations

4.1. Allocating across hierarchies by trends and weights
4.2. Setting minimum and maximum bounds
4.3. Locking Rules
4.4. Multi-dimensional allocations

Read more →
Planning

8. Scenario planning

8.1. Create and configure a Scenario
8.2. Bidirectional Simulations and Bulk Edit
8.3. Compare Scenarios
8.4. Scenarios in Tree layout

Read more →
Planning

9. Data Writeback

9.1. Core Writeback Capabilities
9.2. Destination Configuration
9.3. Writeback Configuration
9.4. Security and Permissions
9.5. Writeback Logs

Read more →

Request a demo

Learn how Lumel helps enterprises deliver real-time integrated reporting and planning applications

Get Lumel Brochure

Enhance your BI, analytics and xP&A use cases with our no-code Data App suite for Power BI.
Download now
Lumel
Look Forward. Think Ahead ®
Leader in Unified Planning & Analytics for the Modern Data Stack.
© Lumel Inc. All rights reserved.
Connect With Us
Headquarters
5920 Windhaven Pkwy,
Plano TX 75093
United States