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