See how to go from a CSV file to a governed, collaborative data app in PowerTable on Fabric Plan. This demo shows how to import data into a Fabric SQL database, clean it with find and replace, enforce approval workflows with an audit log, and add formulas, conditional formatting, dropdowns, filters, and comments.
See how PowerTable preserves record history and automates routine HR processes in one connected experience. This demo shows how to enable slowly changing dimensions (SCD Type 2 and Type 3) to track changes to fields like grade and salary, then use automations to update employee records the moment a resignation form is submitted.
Learn how to configure PowerTable approval settings, including simple approvers, up to three levels of multi-level approval, and rule-based routing by condition. The demo covers submitting staged changes with a description, due date, and priority, reviewing requests in Pending Review with change history and comments, and using Audit to track data and configuration changes.
See how the new Execute Stored Procedure action brings your Fabric SQL database logic into PowerTable automations. This demo shows how to trigger a stored procedure when a record is created, map the customer key from the triggering record, and keep a customer summary table current, with results confirmed in the run history and database.
Learn how to build an integrated project plan using a planning sheet connected to PowerTable sheets and Fabric SQL tables. The demo covers effort and budget distribution rules, a Gantt-layout task table, lookup and reference columns for resource assignment and cost, a cross-tab time entries table for actual effort, and a budget variance column that compares top-down budgets to bottom-up forecasts.
Learn how to use the Calendar Layout in PowerTable to visualize project schedules, manage task timelines, and identify potential risks with a clear calendar-based view.
In this step-by-step tutorial, you’ll learn how to transform project task data into a calendar view that shows what’s planned each month, week, or day. Explore how to configure calendar fields, view task details, adjust task durations, manage overlapping tasks, and use conditional formatting to highlight potential concerns.
Learn how to use the Kanban Layout in PowerTable to visualize project tasks, monitor progress, identify bottlenecks, and manage workflows more effectively.
In this step-by-step tutorial, you’ll learn how to transform a flat task list into a visual Kanban board, organize tasks by stage, and identify where work is getting stuck. Using the Kanban Layout, you can customize task cards, group work by different fields, move tasks between stages, and highlight potential risks through conditional formatting.
Learn how to configure and use the Resource Layout in PowerTable to manage resource assignments, schedule tasks, and customize your project planning view.
In this step-by-step tutorial, you’ll learn how to set up your first Resource Layout after establishing a database connection and loading your data into PowerTable. The Resource Layout helps you view tasks by resource, adjust task schedules, assign unassigned tasks, and create new tasks directly within the layout.
Set up a Multi-Select Relationship Column in PowerTable to display multiple linked values from a related table. Learn how to connect products, bridge tables, and sales reps, and keep relationship data synced automatically in Fabric Plan.