PowerTable sheets
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.
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.
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 threadsNotifications through email and Microsoft Teams
Shareable bookmarks
Plan and execute
Project Gantt charts
Resource allocation views
Time tracking and timesheets
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
Next steps
Connect PowerTable sheets to your data with the steps in the following articles:
Last updated
Was this helpful?