Connect to a Database

Manage your master and transactional data by connecting your existing databases to PowerTable. After establishing the connection, you can edit data, insert rows and columns, set up workflows, and write back changes directly to the connected database.

The following steps explain the process.

Important

This feature is in preview.

Prerequisites

Before you begin, make sure that you have the following prerequisites in place:

• Connections established to the Fabric SQL database and the semantic model that contains the data for your PowerTable.

• A Plan item created in your Fabric workspace.

Create a PowerTable sheet

1. In your Plan, select New PowerTable Sheet or select the PowerTable icon on the landing page. Enter a name for the sheet and select Create.

1. Select Create a New App to create your app. You can also select Explore PowerTable to experience a sample PowerTable app.

1. Select a Connection: Choose a Fabric SQL connection. You can also create a new connection if required.

1. Database Name: Select the Fabric SQL database to store the app metadata. Select Add.

Note

When a new Plan item is created in a workspace, a Fabric SQL database is automatically created for that workspace. This database stores all the plan app metadata for workspace users. You can choose this database.

1. Select Connect after choosing the connection and the database.

Create a table

1. Select Existing Table to connect to an existing Fabric SQL database.

2. Choose the database schema and the table name to connect to.

3. Select Next.

1. PowerTable sheets automatically detect column properties. Review the table configuration. You can modify the input type and/or the primary key if required.

2. Select Finish.

You have now successfully connected to a database and created a table app using PowerTable. Click Save to save your table.

Next steps

Configure access control and automated workflows and approvals for your new app.