Create a planning sheet

This article describes how to get started with your first planning sheet inside planning in Fabric.

Prerequisites#

Before you set up planning sheets, make sure you have the following prerequisites:

Planning in Fabric IQ is now available to organizations worldwide as part of the Microsoft Fabric SKU. New billing meters have also been introduced and are now available for billing.

Create plan item#

  1. From your Fabric workspace, select New item > Plan.
  1. On New Plan, enter a name for your plan, and then select Create.

When you create a plan item, you also automatically create a Fabric SQL database in your workspace. This database stores your plan report's metadata.

Create your planning sheet#

  1. In your new plan item, you see options to get your data from the semantic model or from Excel, and to create a planning sheet from it. Alternatively, start with a planning sheet and then connect it to data.
  1. Select Planning, enter a name for the new planning sheet, and then select Create.

Add the semantic model connection#

In this section, you add the semantic model connection that you created earlier (see the Prerequisites section). The result of this step is that your planning sheet has access to data in the semantic model.

  1. In your new planning sheet, select Add.
  2. Under Select a Connection, connect to your semantic model connection.

Only connections with the Power BI Semantic Model connection type that the current user has access to appear in this dropdown.

  1. Select the semantic model, and then select Add.
  1. Add semantic model data into your fields. Now you have your first planning sheet.

Each Plan item is associated with a single semantic model. To connect to a different semantic model, create a new Plan item.

You can create multiple Plan items within the same billing session. All items you create use the same active billing session, regardless of the number of items or use cases. For more information, see Billing and usage for Fabric Planning.

Optional: Connect to a database for collaboration#

If you want to collaborate with others on this planning sheet, create a database connection for your plan item to store comments and other collaboration details. For more information, see Create a database connection for collaboration.

Fabric Plan
Enterprise planning, integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co-engineered with Lumel.
CERTIFIED BY
Fabric Planning is certified by IBCS
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.