LiveDemo - Open-source alternative to Storylane, Navattic, and Arcade | Product Hunt

How to Edit Data in Power BI


This guide is an interactive LiveDemo. Create interactive demos of your own product: Interactive demo software · Interactive customer onboarding guides · Start free


How to Edit Data in Power BI: step-by-step guide

  1. Open your Power BI Desktop. Go to the 'Home' tab.

  2. Click on 'Transform Data'.

  3. Go to the column where you want to edit data and right-click on your mouse.

  4. Use the dropdown in the column header to change data columns.

  5. You can remove columns by clicking the 'Remove' option.

  6. You can choose to remove duplicates or errors as you like.

  7. You can make changes in the data code as well.

  8. Once done, click 'Close & Apply' to save changes.

Quick answer: To edit data in Power BI Desktop, open the Home tab and click Transform Data. Right-click the target column, use the header dropdown to change columns, remove unwanted columns, duplicates, or errors, and edit data code. Finish by clicking Close and Apply to save your changes.

About this Power BI tutorial

Modify dataset values in Power BI by transforming columns, removing duplicates, and applying changes to your report easily. This guide shows how to edit Data in Power BI in 8 steps, starting with "Open your Power BI Desktop. Go to the 'Home' tab" and finishing with "Once done, click 'Close & Apply' to save changes". The interactive demo above is a click-through copy of the real Power BI interface, so you can rehearse each step before doing it in your own account.

Frequently asked questions

How many steps does it take to edit Data in Power BI?

8 steps. Each one is listed in order above, and the demo highlights exactly where to click.

Can I try it without changing my own account?

Yes. Clicking through the demo doesn't touch your Power BI data or settings. Once you know the flow, repeat it in your own workspace.

This tutorial is filed under Power BI. Related guides: How to Edit Dataset in Power BI, How to Edit Slicer in Power BI and How to Embed a Power BI Project on a Website. Last reviewed 05 Oct 2026.

LiveDemo - Open-source alternative to Storylane, Navattic, and Arcade | Product Hunt
🚀

Create your first interactive demo in minutes

No credit card required • Start building today

Start free→