Best Answer · By JanBask MS SQL Server Expert
Naveen Raj JanBask Expert
Answered on Jan 14, 2020
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