What is Power Query in Power BI?
Power query is used to clean, shape and transform the data.
You can import data from various sources like to databases from files
Append and join data from a wide range of sources
You can shape data as needed by adding and removing it