Enter table data manually

This article explains how to create a table app using PowerTable by entering the data manually from scratch. 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.

Note#

• You can also create a table by uploading data from an Excel or CSV file. For more information, see Create a table app with PowerTable sheets.
• To connect an existing database table to a PowerTable sheet and create a table app, see Connect to a database.
• To learn how to connect to a semantic model, see Connect to a semantic model.

Prerequisites#

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

• Connection established to the Fabric SQL database that stores the data for your PowerTable app.
• A plan item created in your Fabric workspace.

Create a new 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.

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

3. Select a Connection: Choose a Fabric SQL connection if available. If there are no connections, create one by selecting Create Connection.

4. Database Name: Select the Database Name field to open the list of databases available.

5. Select the destination Fabric SQL database to store the table data and then select Add.

6. Select Connect.

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 name for the table. Currently, table names support English characters only.
3. Select Enter Data Manually in the Import Data section.
4. Select Next.

5. Configure your table by adding the column name, primary key, and other relevant details like length, precision, scale, and so on, wherever applicable.

   Note#

   • Currently, column names support English characters only. To display non-English column names, scroll to the right in the column configuration table and set the Display Name property to Japanese or another non-English label to display localized labels in PowerTable.
   • If your data contains Japanese or other non-English text, define those columns' input type as NVARCHAR so PowerTable supports and renders non-English characters correctly.

6. Select Add Column to add a new column. Use the bin icon to delete a column.
7. Select Finish after entering all the column details.
8. An empty table is successfully created using PowerTable, with the configured columns.
9. You can now insert rows into this table using the Insert Row option.
10. Select Preview Changes to preview the added rows and changes.
11. To discard the changes, select Discard Changes.
12. After previewing, select Save to Database and Proceed to save the rows to the table in the database.
13. Finally, select Save at the top right corner to save the PowerTable sheet.

Related content#

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

Next steps#

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