PowerTable
Go to websiteCommunityContact Us
  • INTRODUCTION
    • Welcome to PowerTable
  • GET STARTED
    • Prerequisites
    • Supported Data Platforms
    • Admin Setup Guide (15-day Free Trial)
  • PRODUCT TOUR
    • Explore a sample app
    • Build your first app
    • Layout & User Interface
  • CREATE TABLE APP
    • Introduction
    • Import Spreadsheet Data
    • Connect to Database
    • Enter Data Manually
    • Get Data from Semantic Model
  • WORKING WITH POWERTABLE
    • Basic Table Operations
      • Edit data
      • Bulk Edit
      • Insert rows
      • Bulk Import rows
      • Delete rows
      • Duplicate rows
      • Copy rows
      • Preview Changes
    • Explore data
      • Search and filter
      • Sort and reorder
      • Show/Hide columns
      • Pin columns
      • Column Insights
    • Conditional Formatting
  • COLUMN SETUP
    • Configure Properties
      • General
      • Lookup and Relation
      • Display
    • Upload/Download Configuration
    • Add a Column
      • Add Visual Column
        • Add Formula Column
        • Add Multi-select Relationship Column
        • Add Reference Column
      • Add Database Column
  • ACCESS CONTROL
    • Manage Access
    • Row Permissions
    • Column Permissions
  • APPROVALS
    • Set up Approval Workflow
    • User Approvals
    • Rule-based Approvals
    • Approval using a Lookup Table
    • Multi-level Approvals
    • Notify Approvers via MS Teams
    • Handling Changes Before Approval
    • Review Changes - Approval process
  • WORKFLOWS, AUTOMATION & NOTIFICATIONS
    • Workflow automation
    • Send Mail notifications
    • MS Teams notifications
    • Webhooks
    • Cascade Updates
  • Pause an Automation
  • AUDIT
    • Audit logs
  • COMMENTING & COLLABORATION
    • Commenting
    • View all comments & track changes
    • Assign users & task status
  • APPEARANCE
    • Basic formatting
    • Display Settings
  • USER MANAGEMENT & LOGS
    • PowerTable Console
    • Admin Portal
      • User Management
      • Settings
        • General Settings
        • Writeback Settings
          • Settings
          • PowerTable managed DB
  • MISCELLANEOUS
    • Keyboard Shortcuts
    • Formulas & Functions
Powered by GitBook
On this page
  1. GET STARTED

Prerequisites

PreviousWelcome to PowerTableNextSupported Data Platforms

Last updated 1 month ago

Before you set up PowerTable, you must ensure you meet the prerequisites outlined below. Reach out to your Fabric administrator for further assistance.

Prerequisites:

  • Microsoft Office 365 credentials: PowerTable is a native Microsoft Fabric workload, so you require your Microsoft O365 credentials to log in.

  • Tenant Access: Ensure you’re connected to your organization's tenant.

  • Paid or trial Fabric capacity: Ensure your workspace is on a paid or trial Fabric capacity.

  • Workload Settings: Capacity admins and users with relevant permissions can add Fabric workloads and make them available either to the entire tenant or to a specific capacity. Ensure that users who want to add and use workloads are granted necessary permissions by a Fabric admin.

  • Access to Workspace: Ensure that you have the necessary access permissions (Admin or Member access) to relevant workspaces so you can create PowerTable apps and workspace items.

  • Ensure that the following resource providers are registered in your Azure subscription:

    • Microsoft.Storage

    • Microsoft.Sql

  • Access to databases/warehouses: Ensure you have access to the necessary data platform, database, lakehouse, or warehouse.

  • Whitelist IP addresses in Azure SQL firewall rules: Network firewalls block connections from IP addresses that do not have permissions. You need to whitelist PowerTable's outbound IPs in your Azure SQL database firewall rules.

References

If you encounter any challenges in setting up the PowerTable workload, do not hesitate to reach out to us at our . We understand the product is just under Public Preview, and we are keen to get you started at the earliest.

Workspace license information:

Workspace roles:

Who can add Fabric Workloads -

PowerTable Community
https://learn.microsoft.com/en-us/fabric/enterprise/licenses#workspace
https://learn.microsoft.com/en-us/fabric/fundamentals/roles-workspaces
https://learn.microsoft.com/en-us/fabric/workload-development-kit/more-workloads-add#add-and-remove-workloads
Workspace on a Fabric capacity