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