Master data management (MDM), native to Microsoft Fabric
PowerTable lets business users govern master and reference data where it already lives, inside Fabric. It is a lightweight, warehouse-native MDM layer that complements your MDM platform and manages the forward-looking master data your plans and reports need today.
Activity-based pricing on the Microsoft Fabric capacity you already pay for. No per-seat MDM licenses.
Live on Fabric SQL|Rows: 1,284Pending approvals: 3Audit on
Lightweight MDM, where your data lives
Microsoft Fabric MDM that works with your data platform, not around it
Enterprise MDM platforms are powerful engines with thin, IT-centric front-ends. PowerTable is the business-user layer, inside the Microsoft Fabric environment where your data, plans, and reports already live.
Complements your MDM
Sits beside your enterprise MDM platform as the governed, business-user stewardship and authoring front-end on Fabric. PowerTable doesn't replace a heavy MDM platform; it gives the people who own the data a place to maintain it.
Authors data your MDM doesn't have yet
Author the master data no ERP or MDM platform holds yet: prospective customers, products not yet launched, planning dimensions. This is the data your planning and reporting teams need first.
Governs data in place
Writeback runs natively against Fabric SQL with one security model. No extract, copy, and re-sync into a proprietary store. Fewer reconciliation points, less latency, and master data that stays inside your platform.
Forward-looking master data
The master data your MDM can't hold yet
Traditional MDM and ERP systems are systems of record for what already exists. Planning and reporting teams need entities that don't exist in any source yet, and that's where PowerTable leads.
Forward-looking entities. Future customers, unlaunched products, new cost centers and planning dimensions, authored where your plans live.
No-code, business-user owned. The people closest to the data maintain it directly, with no IT ticket per change.
Promote when it's real. Once an entity is confirmed in the system of record, your MDM platform owns the golden record. PowerTable stays focused on the data that isn't there yet.
Existing customers & productsERP / MDM
Golden record & survivorshipERP / MDM
Prospective customersPowerTable
Products not yet launchedPowerTable
Planning dimensions & ratesPowerTable
Reference data for reportsPowerTable
Stewardship, built in
Govern master data without spreadsheets
Configure fields, rules, and approvals, and stand up a governed data app on Fabric SQL in minutes. Every capability a data owner needs to maintain master data.
No-code data apps
Build governed table apps with lookups, validation, formulas, and hierarchies. Bulk-edit, import, and find-and-replace across records, with no developer required.
Approvals & workflow
Route changes through sequential, multi-level, or rule-based approvals before they commit. Delivered with native Microsoft Teams integration.
Security & audit
Row- and column-level security inherited from the Fabric semantic model and Entra ID, with a full audit trail of every data and access change.
Data-level collaboration
Comment at the cell and record level so context travels with the data. Status tracking gives teams real-time visibility into where each record stands.
Automation & triggers
Trigger workflows on record changes, form submissions, or button clicks. Cascade updates to other Fabric SQL tables and notify owners by email and Teams.
Slowly changing dimensions
Track history natively with SCD support, so reference and dimension changes are preserved for accurate point-in-time reporting and planning.
What you can master
From customer masters to planning dimensions
Pick a domain, configure your fields, rules, and approvals, and run it on Microsoft Fabric SQL.
Customer Master
Product Catalog
Vendor Master
Material Master
GL Account Master
Cost Center
Price Lists
Rate Cards
Contracts
Subscriptions
Stores & Sites
Employee Master
Projects
Discounts
Compliance Register
Asset Register
An honest fit
Where PowerTable leads, and where your MDM still leads
PowerTable is a lightweight MDM layer, not an enterprise MDM platform. Knowing the line is what makes the two work well together.
PowerTable leads
The business-user layer, native to Fabric
Business-user stewardship: no-code authoring, bulk edit, forms
Forward-looking master data & planning dimensions
Warehouse-native writeback: data never leaves Fabric
PowerTable is the governed business-user front-end and forward-looking authoring layer for master data on Fabric: a complement to your MDM platform, and a capable lightweight MDM in its own right for the data and teams it doesn't reach.
Integrated with Planning & Intelligence
Master data that fuels every plan and report
The data your business users maintain flows directly into plans, forecasts, and dashboards, with no exports, ETL, or integration layer to maintain.
Real-time integration
Update a customer master or cost center, and the planning model and intelligence app reflect it immediately. Your apps never run on stale master data.
Fabric-scale
Master data lives on Fabric SQL, so apps handle volumes that exceed traditional tool limits. As your organization grows, Data Management grows with it.
One security model
Fabric workspace roles, Entra ID, and row-level security apply consistently across data apps, plans, and reports. Govern once, enforce everywhere.
Frequently Asked Questions
PowerTable is warehouse-native to Microsoft Fabric. Master data is authored and stored directly in Fabric SQL and OneLake, with no separate Dataverse store to provision, sync, or reconcile. It is purpose-built for data stewardship, with approvals, audit, and one Fabric security model, and it feeds Planning and Intelligence directly. Power Apps is a low-code application platform and Dataverse is its general-purpose data store; PowerTable is a governed master data layer that lives where your Fabric data, plans, and reports already are.
No. PowerTable is a lightweight MDM layer, not an enterprise MDM platform. It complements your MDM platform by giving business users a governed place to steward data and to author forward-looking master data the platform doesn't hold yet. Your enterprise MDM still leads on matching, deduplication, golden-record survivorship, and enterprise syndication.
Master data is stored in Fabric SQL and stays inside your Microsoft Fabric environment. Row- and column-level security is inherited from the Fabric semantic model and Microsoft Entra ID, with a full audit trail of every data and access change.
No. PowerTable is no-code. Business users configure fields, validation rules, hierarchies, and approval workflows, and stand up a governed data app themselves, with no developer required. IT sets the Fabric capacity and security model once; day-to-day stewardship is owned by the people closest to the data.
You can import from files and bulk-load records into a PowerTable app, or build on data that already lives in your Microsoft Fabric environment. Because PowerTable runs on Fabric SQL, you are not standing up an external pipeline to load data or keep it in sync.
Directly. Data in PowerTable sheets can be directly fed into Planning and Intelligence sheets for real-time integration. You could also consume this data through the semantic model layer by connecting to the Fabric SQL tables. Either way, there are no exports, ETL, or integration layer to maintain.
Yes. PowerTable runs on the Microsoft Fabric capacity you already pay for. Data Management, Planning, and Intelligence share that capacity, with activity-based pricing that meters sessions only when users engage, so there are no per-seat MDM licenses. See the pricing and capacity estimator.
PowerTable is the Data Management capability within Lumel's suite for Microsoft Fabric, alongside Planning and Intelligence. The three share one Fabric capacity and one security model, so master data maintained in PowerTable feeds plans and reports directly. You license the Fabric capacity, not separate per-product seats.
Activity Based Pricing
One Fabric capacity. Every user included.
Data Management, Planning, and Intelligence run on the Microsoft Fabric capacity you already pay for. Sessions meter only when users actively engage, so a daily steward and a quarterly reviewer never cost the same. No per-seat MDM licenses, no shelfware. PowerTable is available as part of Fabric Planning.
