Create a planning sheet

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

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.

Prerequisites#

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

  • The connection-based flow for semantic models is deprecated. You can now connect to a semantic model directly by using your signed-in identity without configuring a shared cloud connection.
  • Existing artifacts built by using the shared cloud connections auto-switch, and rows appear on the sheet based on the RLS evaluated against the signed-in user.
  • Cloud connection owners can delete the old connections.

Create a new plan#

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

When you create a Plan item, Fabric automatically provisions a Fabric SQL database (__fabric_plan_sys_db) in your workspace to store the item's metadata.

This database is reserved for Plan metadata. Do not use it for other storage purposes, such as storing business data, configuring a planning sheet writeback destination, or storing PowerTable table data. Create or use a separate Fabric SQL database for these purposes.

Create a planning sheet#

  1. In your plan, you see options to get your data from a 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.

Select the semantic model#

Sourcing data from a Power BI semantic model allows you to bring pre-modeled, centralized enterprise data directly into your planning sheets. By connecting directly to a semantic model, you ensure that your calculations and planning workflows stay synchronized with a single source of truth across your organization.

The connection-based flow for semantic models is deprecated. You can now connect to a semantic model directly using your signed-in identity without configuring a shared cloud connection.

  1. In your new planning sheet, in the Data pane, select Add.
  2. In the Select Semantic Model popup, select the textbox to connect to your semantic model.
  1. Select the semantic model, and then select Add.
  1. Select Connect to fetch data from your semantic model.

Planning also supports using variable libraries to store the semantic model. To learn more, see using variable libraries to connect to semantic models.

  1. The semantic model is connected to your planning sheet. The Data pane displays all your loaded data tables, columns, hierarchies, and measures.
  1. Assign measures, row and column dimensions from your semantic model to the respective buckets in the Fields pane. You are ready to start planning.
  • Each plan is associated with a single semantic model. To connect to a different semantic model, create a new plan.
  • You can create multiple plans within the same billing session. All the plans 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.

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.