How to Edit Data in Power BI
- George Apostolov
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
Open your Power BI Desktop. Go to the 'Home' tab.
Click on 'Transform Data'.
Go to the column where you want to edit data and right-click on your mouse.
Use the dropdown in the column header to change data columns.
You can remove columns by clicking the 'Remove' option.
You can choose to remove duplicates or errors as you like.
You can make changes in the data code as well.
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.
Create your first interactive demo in minutes
No credit card required • Start building today





