Sign in

Enter Data Manually

This article explains how to manually enter data into PowerTable to build an app.

You'll enter data to create a table in a database, then write back any subsequent changes to the same database using the PowerTable sheet.

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.

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#

To create a new table in the database and enter the data manually, follow these steps:

  1. Select New Table.
  2. Choose the database schema and enter a Table Name.
  3. Select Enter Data Manually in the Import Data section.
  4. Select Next.
  1. Configure your table by adding the column name, primary key, and other relevant details like length, precision, scale, etc., wherever applicable.
  1. Select Add Column to add a new column. Use the bin icon to delete a column.
  2. Click Finish after entering all the column details.
  1. An empty table is successfully created using PowerTable, with the configured columns.
  1. You can now insert rows into this table using the Insert Row option.
  1. Select Preview Changes to preview the added rows and changes.
  1. To discard the changes, select Discard Changes.
  2. After previewing, select Save to Database and Proceed to save the rows to the table in the database.
  3. Finally, select Save at the top right corner to save the PowerTable sheet.

Related Content#

  1. Create a table app with PowerTable by importing an Excel or a CSV file
  2. Connect PowerTable sheet to a semantic model
  3. Connect to an existing database

Next steps #

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

Fabric Plan
Enterprise planning, Integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co Engineered with Lumel.
BUILT ON