Ease of use, as it provides an intuitive interface allowing users to perfirm complicated data transformation tasks with simple steps.

Also connectivity to a wide range of data sources, and the support it provides to a large spectrum of data transformations such as filtering, cleaning, merging, and custom column creation. Review collected by and hosted on G2.com.

For some users especially those with no prior data processing experience, Power Query can initially appear overwhelming due to the wide array of functions and capabilities. Review collected by and hosted on G2.com.