How to Change Data in Power BI Table

Making a quick correction or adding a new entry to your data should be simple, but it can feel surprisingly tricky within a Power BI report. If you’ve ever found yourself clicking on a table visual and wondering why you can’t just type in a cell, you’re not alone. This guide will walk you through the proper ways to edit, update, and add data for your Power BI reports, from fixing the original source file to making changes directly within the Power BI interface.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Can't I Just Click and Edit a Cell?

The first thing to understand is that Power BI is fundamentally a visualization and analytics tool, not a data-entry spreadsheet like Excel or Google Sheets. The tables and charts you see in your report are a read-only view of a dataset that has been imported and processed from somewhere else. The data itself doesn't live inside the visual, it lives in the underlying data model.

Think of it like this: your report is the finished meal, the Power BI data model is the kitchen where the ingredients are prepared, and your source file (like an Excel sheet or a database) is the grocery store. You can't change an ingredient just by poking at the final dish on your plate, you have to go back to the kitchen or the grocery store.

This "read-only" approach is a feature, not a bug. It ensures data integrity and consistency. By forcing changes to happen at the source, you create a single source of truth, so every report and every user is working from the same accurate information. The visuals simply update to reflect any changes made to the source data once refreshed.

The Best Practice: Changing Your Original Data Source

The most reliable and recommended method for changing your data is to go back to the original source file or database. This ensures your data remains accurate and consistent everywhere it's used. Once you've made your changes, a simple refresh in Power BI will pull them into your report.

Graphed

Still Building Reports Manually?

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

Watch the Demo

For Excel and CSV Files

This is the most common scenario for many users. The process is straightforward:

1. Locate and open the original file. Find the Excel workbook or CSV file that you connected to your Power BI report.
2. Make your edits. Correct the typos, update the numbers, or add new rows of data directly in the spreadsheet.
3. Save the file. Make sure you save your changes. If it's on a shared drive or SharePoint, ensure the sync is complete.
4. Refresh in Power BI. Open your Power BI report and click the Refresh button on the "Home" ribbon. Power BI will reload the data from the saved file, and your visuals will automatically update to reflect your changes.

Following this process ensures that the source file is always the "master" copy, which prevents confusion down the line.

For Databases (SQL, etc.)

If your data comes from a database like SQL Server, the principle is the same, but the execution is different. Data in a database is usually managed by a specific application or a database administrator.

In this case, you likely won't be able to just "open a file" and make changes. You'll need to use a database management tool (like SQL Server Management Studio) or request that the person responsible for the database makes the necessary update. Once the data is changed in the source database, clicking Refresh in Power BI will pull in the new or corrected values.

Making Changes During Import with Power Query Editor

Sometimes, you can't or shouldn't change the source file itself. Maybe it's a raw data dump from a system you don't control, or maybe you need to clean up messy data every time you load it. In these cases, the Power Query Editor is your best friend. Power Query allows you to define a series of transformation steps that are applied every time your data is refreshed.

To get started, click Transform Data on the "Home" ribbon in Power BI Desktop. This will open the Power Query Editor.

Using "Replace Values" for Corrections

This is perfect for fixing consistent misspellings or standardizing terminology. For example, if your data contains both "USA" and "United States," you can easily fix it.

1. In the Power Query Editor, select the column that contains the data you want to change.
2. Go to the "Transform" tab and click Replace Values (or right-click the column header and select it).
3. In the dialog box, enter the Value To Find (e.g., "USA") and the value you want to Replace With (e.g., "United States").
4. Click OK.

Power Query will record this as an "Applied Step." Now, every time you refresh your report, it will automatically perform that replacement without you having to do it manually.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Creating New Values with a Conditional Column

Sometimes, "changing" data actually means creating a new, categorized version of it. A conditional column can help you add logic to create new values based on existing ones.

Imagine you have a sales table and you want to categorize each sale as "Large" or "Small."

1. In Power Query, go to the Add Column tab and click Conditional Column.
2. A powerful editor will pop up. You can build your logic here. For example:
3. Click OK, and a new "Sale Size" column will be added to your table.

Once you're done making changes in Power Query, click Close & Apply on the "Home" tab to save your transformations and load the modified data into your report model.

For Quick Additions: Using the "Enter Data" Feature

What if you just need to add a small table of information that doesn't exist anywhere else? This could be a static list of department heads, sales targets for the quarter, or any other small dataset you need to create from scratch.

For this, Power BI has a feature called Enter Data.

1. On the Home ribbon in Power BI Desktop, click Enter Data.
2. You'll see a blank grid that looks like a simple spreadsheet. You can type directly into the cells or even copy and paste data from an Excel sheet.
3. Give your table a name at the bottom of the window (e.g., "SalesTargets").
4. Click Load.

Power BI will add this as a brand-new table to your data model. It’s important to remember that this does not add rows to an existing table from another source. It creates a completely separate, independent table. You can then link this new table to your other data tables using relationships in the Model view.

To edit this table later, find it in the "Data" pane on the right, click the three dots (...), and choose Edit query. This will open the source step in Power Query where you can manually adjust the values you entered.

Advanced Techniques for More Control

For more experienced users, there are a couple of other techniques that allow for more dynamic interactions without directly changing the source data.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Simulating Changes with "What If" Parameters

A "What If" parameter is a powerful feature for scenario analysis. It doesn't actually change your dataset, but it allows report viewers to use a slider or input box to see how fluctuations in a number might affect the outcome.

For example, you could create a parameter to simulate a sales commission rate. The user could move a slider from 3% to 10% and see a "Projected Commission" visual update in real-time. This is great for forecasting and modeling but isn't for correcting or adding permanent data.

Using Power BI Dataflows

If you find yourself performing the same Power Query transformations across multiple different Power BI reports, you might be ready for Dataflows. A Dataflow is essentially Power Query in the cloud. It allows you to clean and prepare data once, then save that clean dataset in Azure for multiple report creators to use. This centralizes your data logic and ensures everyone in your organization is starting from the same clean, standardized dataset.

Final Thoughts

Reviewing how to handle your data is key to mastering Power BI. It's best to always treat the original source as your single source of truth and make corrections there. For data cleaning and shaping tasks that you need to repeat, the Power Query Editor is a powerful tool. And for small, one-off tables, the "Enter Data" feature provides a quick and easy solution.

All these steps - connecting sources, cleaning data, and keeping reports live - are often the most time-consuming part of analytics. That's why we built Graphed to simplify this entire process. We connect directly to your marketing and sales platforms (like Google Analytics, Shopify, Facebook Ads) and handle the data pipeline for you. Instead of navigating editors and worrying about refreshes, you can just ask questions in plain English to get real-time, self-updating dashboards, freeing you up to focus on the insights, not the data wrangling.