In Power Query, data transformation involves importing data from various sources, then performing steps like filtering rows, removing duplicates, pivoting/unpivoting columns, merging queries, and applying custom calculations using the M language. Each transformation step is recorded and can be modified as needed.