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:

1. Import your spreadsheet data and build an app

2. Connect to an existing database table and build an app

3. Directly type in data in the app and create a table in the database

4. Connect to an existing semantic model and build an app

Note that in the above methods #1 to #3, the source and destination for the app will be the same - i.e., underlying database table.

When you connect to a semantic model (method #4), the semantic model would be the source, and the destination will be the database table. You can use this method to build writeback-enabled applications. You also have the option of scheduling a refresh from the semantic model.

For now, we will explore how to import data from a CSV file and build an app.

1. Go to your Microsoft Fabric workspace folder. Click on New item to create a new item.

Create a new item

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

Select 'PowerTable'

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

Create PowerTable item

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

Create a New App

1. 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.

Creating a new connection

If you have shared database connections or an existing private connection, you can skip step #5. Instead, you can click on 'Existing Connection' and select any of them to connect to and click Next.

1. 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.

Setup Connection

1. 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').

Create new table

1. Enter the table name and choose Upload Excel/CSV.

Note that you can also choose to connect to an existing semantic model or enter data manually within the app.

Upload CSV

1. Select the file you want to upload.

Select the file

1. Preview the uploaded data and click Next.

Preview Data

1. PowerTable detects column properties automatically. Edit them if necessary. You can also add new columns in this step if you wish to. After verifying the details, click Finish.

Click 'Finish'

You have now successfully built your first app using PowerTable.

Product table

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.