PowerTable

What is PowerTable?

PowerTable is a no-code reference data management and productivity data app platform built for Microsoft Fabric. It lets you build collaborative table apps instantly from database tables and semantic models without writing any code.

PowerTable provides an Excel‑like editing experience combined with enterprise data governance. Users can create, update and manage structured data while maintaining live synchronization with the underlying database.

You can use PowerTable for data entry, workflow management, automation, and project planning within a unified interface. Changes made within PowerTable are written back to the source system, ensuring that operational updates remain synchronized with the organization’s data platform.

PowerTable is designed for organizations that require reference data management, collaborative planning, operational workflows, project execution, and automation directly within the data platform.

Key capabilities

Build without code	Instant table apps from the database with 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 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

Why PowerTable?

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 addresses 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.

PowerTable: Step-by Step

Prerequisites

1. Set up a DMT connection for the Fabric SQL database.

2. Set up a DMT connection for the semantic model.

3. Create a Fabric SQL database to store your app's metadata.

Follow these steps to get started with PowerTable:

1. Create a Plan: Create a Plan in your workspace on Microsoft Fabric.

2. Create a PowerTable sheet: Create a PowerTable sheet inside Plan.

3. Create a table: Connect to data to create a table. You can create your table in the following ways:

• Connect to an existing database

• Import data from Excel or CSV file

• Typing in data directly on PowerTable

• Connect to a semantic model

1. Configure Columns: Configure the table columns and their properties. While PowerTable automatically detects column properties, you can modify them as required.

2. 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.

Related content

• Create a table app with PowerTable

• Connect to Semantic Model