How to Enter Data in Power BI Table

Need to quickly add a small batch of your data directly into a Power BI report? It's a surprisingly simple and useful feature. Whether you're building a quick mockup, creating a lookup table to categorize data, or setting up parameters for a what-if scenario, manually entering data can save you the hassle of creating and connecting a separate spreadsheet. This tutorial will walk you through exactly how to create, edit, and use manually entered tables in Power BI Desktop.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Would You Manually Enter Data into Power BI?

Working in business intelligence often means connecting to well-structured data sources like databases, APIs, or CRMs. So why would you ever type data directly into an advanced analytics tool? It turns out there are several practical reasons why this feature is incredibly helpful for report builders.

Creating Small Lookup Tables

This is the most common use case. Often, your primary data source contains codes or jargon that aren't user-friendly. For example, a sales database might use opportunity stages like '01-Prospecting', '02-Qualifying', '03-Proposal', but you want your report to simply say 'Prospecting', 'Qualifying', and 'Proposal'. By entering a small table with two columns ('Code' and 'Stage Name'), you can link it to your main data in the data model and use the friendlier text labels in your charts and slicers.

• Example: A table to translate status codes: (1 → "Open", 2 → "In Progress", 3 → "Closed").
• Example: A table listing official product categories to group individual SKUs.

Mapping and Categorization

Sometimes you need to group data in ways that don’t exist in your original source. Imagine you have a list of sales representatives from across the United States, but you want to analyze performance by region (e.g., West, Southwest, Midwest, Northeast). Your sales data might not have a 'Region' column. You can manually create a table that maps each sales rep to their designated region. Once you create a relationship between this new table and your main data, you can build visualizations showing performance by region.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Scenario Analysis or 'What-If' Parameters

Manually created tables are fantastic for scenario planning. Imagine you want to create a slicer that allows report viewers to see projected revenue based on different growth assumptions. You could create a small, one-column table with values like:

• 0% Growth
• 5% Growth
• 10% Growth
• 15% Growth

You can then use this table to create a DAX measure that calculates the projected revenue based on the user's selection in the slicer. It's a simple, effective way to make your reports more interactive and forward-looking without changing your core data.

Quick Prototyping and Mockups

Sometimes you need to build a report before the actual data pipeline is ready. You might know what the data will look like, but you don't have access to it yet. By entering a small sample table with a few dozen rows, you can get a head start on designing your visuals, creating your layout, and testing your DAX measures. This allows you to show stakeholders a working prototype and get feedback early, long before the backend is complete.

Your Step-by-Step Guide to Creating a Table in Power BI

Creating your own table is done right within Power BI Desktop. Just follow these simple steps. Note: This feature is only available in Power BI Desktop, not in the Power BI Service (the web version).

Step 1: Open Power BI Desktop and Find the 'Enter data' Button

First, open your Power BI report (.pbix file) or start a new one. On the main Home tab of the ribbon at the top, look for the 'Data' section. You'll see a button labeled Enter data with an icon of a small table.

Clicking this button will open the Create Table dialog box, which is your workspace for entering the data.

Step 2: Create Your Table and Columns

The Create Table window shows a grid that looks like a miniature spreadsheet. By default, it starts with a single column named 'Column1'.

• To Rename a Column: Double-click the header ('Column1') and type a descriptive name, like 'Region' or 'ProductID'. Press Enter. It's essential to give your columns clear names so you know what they are later.
• To Add a New Column: A new, blank column with an asterisk (*) in the header is always waiting for you on the far right. Click into any cell in that column to activate it and then rename its header.
• To Add a New Row: Similarly, a new, blank row with an asterisk is always waiting at the bottom. Start typing in it to add a new row to your table.

Step 3: Enter Your Data

Now, simply click into the first cell (under your newly named header) and start typing your data. You can navigate the grid just like you would in Excel:

• Press Tab to move to the cell on your right.
• Press Enter to move to the cell directly below.
• Use your arrow keys to move freely around the grid.

Let's create a simple example table for Sales Managers and their regional assignments. Your grid might have two columns: 'Sales Manager' and 'Region'. Populate it with a few names and their corresponding regions.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 4: Naming and Loading Your Table

Before you finish, look at the bottom of the Create Table window. There's a field labeled Name. Power BI will suggest a name like 'Table', but you should always change this to something meaningful, such as 'Regional Assignments' or 'Status_Lookup'. A descriptive name makes it much easier to find and use in your data model later on.

Once you've entered your data and named your table, you have two options:

• Load: This is the most common choice. It loads the table directly into your Power BI data model. You'll see your new table appear in the Data pane on the right side of Power BI Desktop, ready to be used.
• Transform Data: This loads the table and immediately opens the Power Query Editor. This is a good option if you know you need to make further adjustments, like changing data types or merging it with other data, before it's loaded into the final model.

For most simple cases, clicking Load is all you need. Congratulations, you've successfully entered data into a new table in Power BI!

Editing and Managing Your Manually Created Table

What happens when you need to add a new sales manager to your table or fix a typo? Your manually entered data is not permanently set in stone. However, editing it isn't as simple as clicking a cell in a visual, you have to go back to the source.

How to Edit Your Data

To edit the contents of your manually created table, follow these steps:

1. In Power BI Desktop, go to the Data pane on the right-hand side.
2. Find the name of the table you created.
3. Hover over the table name and click the three dots (...) that appear, or right-click on the table name.
4. From the context menu, select Edit query. This will open the Power Query Editor.
5. In the Power Query Editor, look at the Applied Steps pane on the right. The very first step should be named Source.
6. Click the small gear icon (⚙️) next to the Source step.

This will reopen the same Create Table dialog box where you first entered your data. From here, you can add, delete, or modify any of the cells, rows, or columns. Once you're done, click 'OK' and then 'Close & Apply' in the Power Query Editor to save your changes.

Changing Column Data Types

When you enter data, Power BI does its best to guess the data type for each column (e.g., Text, Whole Number, Decimal Number, Date). It doesn't always get it right. For instance, a column of numeric IDs might be interpreted as a number to be summed, when it should be treated as text.

It's best practice to set the correct data types in the Power Query Editor. With your table open in Power Query, click the icon to the left of the column header (it might show 'ABC' for text or '1.2' for decimal). You can then select the correct data type from the list. This ensures calculations and relationships work as expected.

Best Practices and Important Limitations

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Keep It Small and Simple

The Enter data feature is designed for small, static datasets. Think a few dozen, maybe up to a hundred rows. It is NOT a replacement for data sources like Excel, SharePoint lists, or SQL databases. Trying to manually input or manage large tables this way is highly inefficient and prone to errors. If your "lookup table" has hundreds or thousands of rows, it's far better to manage it in a dedicated file and connect to it as a proper data source.

It's Static 'Hard-Coded' Data

The single biggest limitation to understand is that this data is static. It is stored inside of your .pbix file and does not automatically update from any external source. If a sales role changes, you must manually open the Power BI Desktop file, go into the Power Query Editor, and update the table yourself. This makes it unsuitable for transactional data that changes frequently, like daily sales logs or web traffic.

A Quick Shortcut: Pasting from Your Clipboard

Did you know you can copy a range of cells from an Excel sheet or a web page table and paste it directly into the Create Table window? Simply click into the top-left cell of the grid and press Ctrl + V (or Cmd + V on a Mac). Power BI will automatically create the columns and populate the data, saving you a lot of typing.

Final Thoughts

Manually entering data in Power BI is a remarkably practical tool for adding small, static tables like lookup lists or what-if parameters to a report. By using the Enter data feature, you can quickly enrich and add context to your main dataset without the need for managing a separate external file for just a few bits of information.

While building in tools like Power BI offers deep control, it can involve many clicks and a lot of manual configuration to get your dashboard just right. That’s why we built Graphed. Our approach lets you connect to your marketing and sales data a whole lot faster. You build rich, interactive dashboards and get answers just by asking questions in plain English - no wrestling with data models or table editors needed. Just ask, "Show me last month’s website sessions by traffic source from Google Analytics," and the charts are built for you, in real-time.