EDITable lets you add new columns to the source database directly from the visual.
To add a new column, click on Manage Columns > Add Database Column.
Add Database Column
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.
Refresh the Power BI source.
Refresh source
The column is now available in the Data pane.
Added column in the Data pane
Assign it to the 'Columns' field to add it to the EDITable visual.
Assign the column
To configure the newly added column, click the highlighted link on the visual.
Click to configure
Configure the column properties as you would for any other columns, and then click Save.
Configuring the added column
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.
