How to Manually Add Row to Table in Power BI (With Example)


The easiest way to add a row to a manually created table in Power BI is to click the Gear icon next to Source under Applied Steps in the the Power Query Editor.

The following example shows how to do so in practice.

Example: How Manually Add Row to Table in Power BI

Suppose we would like to manually create a table in Power BI.

To do so, click the Home tab along the top ribbon, then click the Transform data icon:

This will bring up the Power Query Editor.

Next, click the Enter Data icon under the New Query group on the Home tab:

Next, we will enter the following data that contains information about various basketball players:

Once we click OK, the table will be created:

Now suppose that we would like to add more rows to the table.

To do so, click the Gear icon next to Source under Applied Steps in the the Power Query Editor.

Power BI add row to table

This will bring up the Create Table window once again where you can manually add a new row to the table.

For example, we may decide to add one new row that contains information about a basketball player on the Magic team:

Once we click OK, this new row will be added to the table:

Feel free to add as many new rows as you would like.

Additional Resources

The following tutorials explain how to perform other common tasks in Power BI:

How to Add Index Column to Table in Power BI
How to Count Distinct Values in Column in Power BI
How to Count Number of Occurrences in Power BI

Leave a Reply

Your email address will not be published. Required fields are marked *