# How to Edit Data in Power BI

> 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.

Canonical: https://livedemo.ai/tutorials/how-to-edit-data-in-power-bi/
Apps: Power BI
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3c7bab56e05a00fe3f3f/preview?step=1

## Steps

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.
