Quick summary
The Power Query Editor in Power BI is the built-in data transformation tool that lets you clean, reshape, and prepare data before it loads into your reports. You can launch it by importing data and clicking Transform Data directly from the Power BI Desktop interface.
Steps
- Open Power BI Desktop and select a data source to start with.
- Import data from Excel.
- Click 'Transform Data' to open it directly in the Power Query Editor.
- Follow the steps to launch the Power Query Editor window and begin transforming your data.
