Add Database Column

EDITable lets you add new columns to the source database directly from the visual.

1. To add a new column, click on Manage Columns > Add Database Column.

Add Database Column

1. In the pop-up window, you can enter the column name and its data type. You can optionally make it a non-nullable column and assign a default value. Then click Create.

In the example below, we have added an email ID column with the name 'EmployeeEmailID' and data type VARCHAR.

Adding a column to the database

After clicking on Create, you can see the below toast message.

1. Refresh the Power BI source.

Refresh source

1. The column is now available in the Data pane.

Added column in the Data pane

1. Assign it to the 'Columns' field to add it to the EDITable visual.

Assign the column

1. To configure the newly added column, click the highlighted link on the visual.

Click to configure

1. Configure the column properties as you would for any other columns, and then click Save.

Configuring the added column

1. After saving the configuration, go to the 'Home' tab to view the new column added to the source database.

Added column

Please note that you cannot delete a column directly from the visual—this must be done from the database. Alternatively, you can simply remove the field from the 'Columns' field well.