Notiz
Zougrëff op dës Säit erfuerdert Autorisatioun. Dir kënnt probéieren, Iech unzemellen oder Verzeechnesser ze änneren.
Zougrëff op dës Säit erfuerdert Autorisatioun. Dir kënnt probéieren, Verzeechnesser ze änneren.
The PowerTable sheets component of plan (preview) is a no-code reference and master data management and productivity app platform in Microsoft Fabric. It enables users to build collaborative table apps directly from database tables and semantic models without writing code.
Important
This feature is in preview.
PowerTable sheets provide an Excel-like editing experience combined with enterprise data governance. With this, users can quickly create, update and manage structured data while maintaining live synchronization with the underlying database.
You can use PowerTable sheets for structured data entry, reference data management, collaborative planning, operational workflow management, project planning and execution, and automation directly within the data platform. All modifications are written back to the source system to maintain operational data synchronization.
Why use PowerTable sheets?
Organizations frequently rely on spreadsheets, disconnected tools, or custom data applications to manage operational data. These approaches create challenges such as lack of governance, data silos, inconsistent change tracking, and manual workflow monitoring.
PowerTable sheets address these challenges by enabling teams to build governed data applications directly on enterprise data platforms. It allows organizations to manage operational data, approvals, and automation while keeping analytics and operations connected.
Key capabilities
The following table lists the core capabilities of PowerTable sheets.
| Capability | Description |
|---|---|
| Build without code | - Instant table apps from the database with live sync - Drag-and-drop interface builder - Excel-like editing experience - Forms, filters, and custom views - Lookups and calculated columns |
| Collaborate seamlessly | - Multi-user concurrent editing - Approval workflows and governance - Comments, @mentions, and threads - Notifications through email and Microsoft Teams - Shareable bookmarks |
| Plan and execute | - Project Gantt charts - Resource allocation views - Time tracking and time sheets - Task management and status tracking - Automated triggers and webhooks |
| Control and audit | - Enterprise-grade permissions - Full change history and audit logs - Row-level and column-level security - Compliance-ready support for Type II SCD - Integration with OneLake for analytics |
Overview of PowerTable sheet steps
Prerequisites
Before you begin, make sure that you have the following prerequisites in place:
- A Fabric SQL database to store the app metadata.
- Connections or data sources established to the Fabric SQL database and the semantic model.
Create a PowerTable sheet
Follow these steps to get started with PowerTable sheets:
Create a plan: Create a plan (preview) item in your Fabric workspace.
Create a PowerTable sheet: Create a new PowerTable sheet inside the plan.
Create a table: Connect to data to create a table. You can create your table in the following ways:
- Connect to an existing database
- Upload Excel or CSV file
- Type data directly into the PowerTable sheets
- Connect to a semantic model
Configure Columns: Configure the table columns and their properties. While PowerTable sheets automatically detect column properties, you can modify them as required.
Save changes to the source: Your table app is ready. You can now read and write on your table app and synchronize the changes back to the source.
Next steps
Connect PowerTable sheets to your data with the steps in the following articles: