How to Edit Data in Power BI

Quick summary

Editing data in Power BI Desktop is done through the Power Query Editor, which lets you transform, remove, and clean columns before loading data into your reports. Using the Transform Data option and the column context menu, you can remove duplicates, fix errors, and apply changes with a single click of Close & Apply.

Steps

1. Open Power BI Desktop and navigate to the Home tab.
2. Click Transform Data to open the Power Query Editor.
3. Go to the column where you want to edit data and right-click to open the context menu.
4. Use the dropdown in the column header to change data column settings.
5. Click the Remove option to delete unwanted columns.
6. Choose to remove duplicates or remove errors from the column as needed.
7. Make any additional changes directly in the data code view.
8. Click Close & Apply to save all changes and load the updated data.