How To Add Data To Existing Table In Power Bi

by

Adding Data to an Existing Table in Power BI

To add data to an existing table in Power BI, you can follow these steps:

  1. Open your Power BI desktop application and navigate to the report or dashboard where the table is located.
  2. Select the table you want to add data to by clicking on it.
  3. Once you select the table, go to the “Modeling” tab in the ribbon at the top of the application.
  4. In the “Modeling” tab, click on the “Enter Data” button.
  5. A dialog box will appear where you can input the data you want to add to the table. Enter the data in the required format.
  6. After entering the data, click on the “Load” button to add the data to the table.

Here’s an example to illustrate the process:

Let’s say you have a table in your Power BI report called “Sales” which contains columns like “Product Name”, “Quantity”, and “Revenue”. You want to add new sales data to this existing table.

1. Open Power BI desktop.

2. Navigate to the report or dashboard where the “Sales” table is located.

3. Click on the “Sales” table to select it.

4. Go to the “Modeling” tab in the ribbon at the top of the application.

5. Click on the “Enter Data” button.

6. In the dialog box that appears, enter the new sales data. For example:

Product Name Quantity Revenue
Product A 100 5000
Product B 50 2500

7. Once you have entered the data, click on the “Load” button.

8. The new sales data will now be added to the “Sales” table in your Power BI report.

By following these steps, you can easily add data to an existing table in Power BI.

Leave a comment