TRAINING · SKILLS HUB

Learn Fabric Planning, one episode at a time

Short video episodes grouped into seasons. Pick a season and watch the episodes in order
Before you start
A Fabric workspace where you can add a Plan work item
A Power BI semantic model to plan against
The Planner role, Admin or Member, since the DMTS episodes need it
Set-up steps for all three, in one guide
Download PDF guide

Planning · Season 1

The Introductory Voyage

The end-to-end first run. Stand up a Plan work item, point it at a semantic model, and build a Planning app people can actually type into, measures, notes, comments, formatting and roll-ups included.

10 episodes · 27 min total

Play season
  1. Fabric Plan - Skills Hub - Episode 1 - Create a Plan work item Duration 2:39

    Episode 1

    Create a Plan work item

    Every planning app in Microsoft Fabric lives inside a Plan work item, and this episode creates your first one. Before you can, two switches have to be on: Fabric IQ enabled for your tenant, and the Plan work item itself enabled by your tenant admin.…

    Duration 2:39
  2. Fabric Plan - Skills Hub - Episode 2 - Connect the Semantic Model with Fabric Plan Duration 0:44

    Episode 2

    Connect the Semantic Model with Fabric Plan

    A Plan work item is empty until you point it at data, and in Microsoft Fabric that means connecting your semantic model through a DMTS connection. This episode covers both routes: picking a DMTS connection that already exists in your workspace, or creating one from…

    Duration 0:44
  3. Fabric Plan - Skills Hub - Episode 3 - Create a Planning App Duration 3:46

    Episode 3(sign in to watch)

    Create a Planning App

    Time to build the planning app itself - the sheet your planners will work in. Starting from a blank canvas, this episode walks through the Data pane, the Fields pane and the Fabric SQL database connection that makes the app collaborative. Then the build: six…

    Duration 3:46
  4. Fabric Plan - Skills Hub - Episode 4 - Add a Data Input measure Duration 2:21

    Episode 4(sign in to watch)

    Add a Data Input measure

    Everything so far has been read-only. This episode makes the sheet writable. A measure from the semantic model is a native measure; anything created inside the planning app is a visual measure - and the first one we build is a data input measure, Revenue…

    Duration 2:21
  5. Fabric Plan - Skills Hub - Episode 5 - Add a Formula measure Duration 3:12

    Episode 5(sign in to watch)

    Add a Formula measure

    If you have spent years writing formulas across cell ranges in a spreadsheet, this episode is the reset. We add Product Selling Price from the semantic model, then create a formula measure called Units Actual - Revenue Actual divided by Product Selling Price - set…

    Duration 3:12
  6. Fabric Plan - Skills Hub - Episode 6 - Add a Visual Column Duration 2:16

    Episode 6(sign in to watch)

    Add a Visual Column

    Not everything in a planning sheet is a number that changes every month. Owners, dates, statuses and names belong to the row, not the time period - and that is what a visual column is for. We tidy the view first (column grand total off,…

    Duration 2:16
  7. Fabric Plan - Skills Hub - Episode 7 - Adding Notes Duration 2:03

    Episode 7(sign in to watch)

    Adding Notes

    A number without its reasoning is a number nobody trusts. Notes are where the assumption behind the figure goes, and there are two ways to use them: attached to a single selected cell with formatted free text, or as a dedicated notes column that stores…

    Duration 2:03
  8. Fabric Plan - Skills Hub - Episode 8 - Collaborative Comments Duration 2:51

    Episode 8(sign in to watch)

    Collaborative Comments

    Notes record what you were thinking. Comments are how you get someone else to act. This episode adds a cell-level comment, shows why an untagged comment notifies nobody, then tags a user - and with Teams notification toggled on in settings, the mention lands directly…

    Duration 2:51
  9. Fabric Plan - Skills Hub - Episode 9 - Manage Aggregations Duration 3:19

    Episode 9(sign in to watch)

    Manage Aggregations

    The numeric values of your measures can be aggregated directly inside the Planning Sheet. This episode pulls Selling Price in as a column from the Products table rather than a DAX measure, forces it from Average to Sum, and shows why the number immediately looks…

    Duration 3:19
  10. Fabric Plan - Skills Hub - Episode 10 - Basic Formatting Duration 3:24

    Episode 10(sign in to watch)

    Basic Formatting

    The model is right - now make it readable. The closing episode of Season 1 clears what is no longer needed, hides the header, and adds a dollar sign to Revenue Plan through prefix and suffix insertion. Then into the Format tab and the extended…

    Duration 3:24
Microsoft, Azure, Copilot, Excel, Fabric IQ, Microsoft Entra, Microsoft Fabric, Microsoft Teams, OneLake, Outlook, Power Automate, Power BI and SharePoint are trademarks of the Microsoft group of companies. IBCS is a registered trademark of IBCS Association. All other trademarks are the property of their respective owners.

This community is operated independently by Lumel. Nothing on this site constitutes a representation or warranty by Microsoft.