Build your first app
PowerTable is a native workload on Microsoft Fabric. This section will help you create your first app in a few simple steps.
There are several ways to create an app with PowerTable:
Import your spreadsheet data and build an app
Connect to an existing database table and build an app
Directly type in data in the app and create a table in the database
Connect to an existing semantic model and build a writeback-enabled app
For now, we will explore method #1, where we import data from a CSV file and build an app.
Go to your Microsoft Fabric workspace folder. Click on New item to create a new item.

Select PowerTable from the list of items. You may want to add it to your favorites by clicking on the star icon.

Enter a name for your PowerTable app and select the workspace. Click on Create.

Click on Create a New App to create your app. You may also select 'Explore PowerTable' to experience a sample PowerTable app.

Creating a new database connection: The next step is to create a new database connection in your preferred data source. Your app synchronizes its data with this data store. Follow the steps below to create a new connection:
Click on New Connection.
Choose your preferred data platform. We'll connect to the Fabric SQL database.
Click Next.


Setup Connection: Enter the connection type and a unique connection name. Select the workspace and the database from the list of options and click Next. Your new private connection is now created.

Choose your table where the data will be stored: Here, you have two options:
Select Existing Table to connect to an existing table in the database (or)
Select New Table to create a new table in the database.
For our demonstration, we'll select New Table to create a new table and import our CSV data. We'll also choose a database schema (in this case— 'dbo').

Enter a name for the table and choose Upload Excel/CSV.

Select the file you want to upload.

Preview the uploaded data and click Next.

PowerTable detects column properties automatically. You can edit them if needed. Choose the primary key. You can also add additional columns in this step, using the Add Column option. After verifying the details, click Finish.

You have now successfully built your first app using PowerTable.

To get the most out of PowerTable, you will need to perform one or more steps listed below. We'll cover them in detail later.
Configuring field properties
Defining access control permissions
Configuring workflow approvals
Setting up automation including triggers, cascading updates, and email/Microsoft Teams notifications
... and more.
Last updated