How to Add a New Table in Power BI
Adding a new table in Power BI is a simple process. Here’s a step-by-step guide with examples:
- Open Power BI Desktop and click on the “Home” tab in the ribbon.
- Click on the “Enter Data” button in the “Home” tab’s toolbar. This will open a dialog box for entering new data.
- In the dialog box, enter the column names for your new table. For example, let’s say we want to create a table for tracking sales data. We can have columns like “Product”, “Region”, “Quantity”, and “Revenue”.
- Once you have entered the column names, you can start entering the data for each column. For example:
- After entering the data, click on the “Load” button to load the new table into Power BI.
- The new table will now appear in the “Fields” pane on the right-hand side of the Power BI window. You can drag and drop the columns from this table into your reports and visualizations.
Product | Region | Quantity | Revenue |
---|---|---|---|
Product A | North | 100 | $1000 |
Product B | South | 200 | $2000 |
Product C | East | 150 | $1500 |
By following these steps, you can easily add a new table in Power BI and start analyzing your data.