Lumel launches PowerTable as a native workload for Microsoft Fabric 

Lumel is excited to announce the public preview of PowerTable, which is available as a native Microsoft Fabric workload. 

"Enterprises have adopted modern data platforms, but data apps continue to operate on replicated data in silos. Next gen apps like PowerTable push down all processing to your cloud data platform so that there is no need for complex ETL or replication. PowerTable takes advantage of multiple Fabric workloads to deliver powerful no-code data apps in minutes,” said Dipti Borkar, VP & GM Fabric at Microsoft. 

PowerTable allows business users to build no-code, writeback-enabled table apps on Microsoft Fabric. It connects live (with bi-directional sync) to your cloud data warehouse tables in platforms such as Fabric SQL, Fabric Data Warehouse, Microsoft Azure SQL, and other external resources and data technologies.   

There are three key use cases for PowerTable: 

1. Build tabular apps for data typically maintained in Excel such as product price lists, contract trackers, project status updates, etc.  

2. Manage master data / reference data / meta data supporting your reporting and planning applications. PowerTable supports forward-looking master data (unlike your ERP and MDM platforms) such as prospective customers or products that are not yet launched. 

3. Build applications on top of your semantic models and facilitate user data input and data writeback. 

PowerTable delivers the following features: 

• Bulk insert and bulk edit records  

• Cell-level commenting and collaboration 

• Change log with audit trail 

• Support for slowly changing dimensions (SCD Type II) 

• Row-level CRUD user permissions 

• Field-level permissions 

• Sequential, multi-level approvals 

• Rule-based approvals  

• Outlook and Teams notifications 

• Workflow automation  

• Triggers and cascading updates 

• Webhook integration 

• … and more 

Unlike products like Airtable or Smartsheet, which typically struggle to handle more than tens or hundreds of thousands of rows, PowerTable is highly scalable and can support millions of rows. This is possible because our architecture separates the user interface from storage and compute and uses pushdown SQL statements to perform all processing on the underlying database of your choice.  

Visit  https://powertable.com/ to learn more.