Microsoft Power Query Logo Award Winner Product Badge
Microsoft Power Query Logo Award Winner Product Badge
Microsoft Corporation

Microsoft Power Query

Composite Score
8.5 /10
CX Score
8.7 /10
Category
Microsoft Power Query
8.5 /10

What is Microsoft Power Query?

Power Query is a data transformation and data preparation engine. Power Query comes with a graphical interface for getting data from sources and a Power Query Editor for applying transformations. Because the engine is available in many products and services, the destination where the data will be stored depends on where Power Query was used. Using Power Query, you can perform the extract, transform, and load (ETL) processing of data.

Company Details


Need Assistance?

We're here to help you with understanding our reports and the data inside to help you make decisions.

Get Assistance

Awards & Recognition

Microsoft Power Query won the following awards in the Data Preparation for Analytics category

Filter By

Microsoft Power Query Ratings

Real user data aggregated to summarize the product performance and customer experience.
Download the entire Product Scorecard to access more information on Microsoft Power Query.

Product scores listed below represent current data. This may be different from data contained in reports and awards, which express data as of their publication date.

88 Likeliness to Recommend

1
Since last award

93 Plan to Renew

2
Since last award

86 Satisfaction of Cost Relative to Value

1
Since last award


Emotional Footprint Overview

Chart with 5 data points.
The chart has 1 X axis displaying categories.
The chart has 1 Y axis displaying values. Range: 0 to 100.
End of interactive chart.
{y}
{name}

Emotional Footprint Overview

Product Experience:
92%
Negotiation and Contract:
84%
Conflict Resolution:
87%
Strategy & Innovation:
91%
Service Experience:
86%

Product scores listed below represent current data. This may be different from data contained in reports and awards, which express data as of their publication date.

+88 Net Emotional Footprint

The emotional sentiment held by end users of the software based on their experience with the vendor. Responses are captured on an eight-point scale.

How much do users love Microsoft Power Query?

Chart

Bar chart with 10 data series.
The chart has 1 X axis displaying values. Range: -0.5 to 0.5.
The chart has 1 Y axis displaying values. Range: 0 to 100.
End of interactive chart.
2% Negative
7% Neutral
91% Positive

Pros

  • Helps Innovate
  • Reliable
  • Continually Improving Product
  • Enables Productivity

Feature Ratings

Average 83

Intelligent Alerts and Notifications

100

Data Connectors and Data Mashup

86

Data Integration

86

Data Profiling

84

Data Pre-Processing

84

Data Enrichment

83

Data Cleansing

82

Data Access

81

Data Packaging

81

Cataloging

80

Data Modelling Tools

78

Vendor Capability Ratings

Average 80

Business Value Created

84

Ease of Data Integration

84

Ease of Implementation

81

Breadth of Features

81

Product Strategy and Rate of Improvement

80

Quality of Features

80

Availability and Quality of Training

80

Ease of IT Administration

79

Usability and Intuitiveness

79

Vendor Support

78

Ease of Customization

74

Microsoft Power Query Reviews

Ogunleye A.

  • Role: Operations
  • Industry: Banking
  • Involvement: End User of Application
Validated Review
Verified Reviewer

Submitted Apr 2024

Great Product!

Likeliness to Recommend

9 /10

What differentiates Microsoft Power Query from other similar products?

Ease of transforming data and also the ease of integrating data from Power query to excel or Power bi !.......Like so Comfortable for me!

What is your favorite aspect of this product?

the data transformation part and also the data modeling part

What do you dislike most about this product?

Inability to efficiently fix errors in the data transformation process, is so frustrating!

What recommendations would you give to someone considering this product?

Power Query is best compatible with excel and a manageable companion for Power Bi

Pros

  • Helps Innovate
  • Reliable
  • Performance Enhancing
  • Enables Productivity

Cons

  • Charges for Enhancements
  • Vendor Friendly Policies

A.K.M Mahmudul I.

  • Role: Information Technology
  • Industry: Banking
  • Involvement: End User of Application
Validated Review
Verified Reviewer

Submitted Apr 2024

Super easy product

Likeliness to Recommend

7 /10

What differentiates Microsoft Power Query from other similar products?

Easy to data analytics

What is your favorite aspect of this product?

Features and ease of use

What do you dislike most about this product?

Row limitation

What recommendations would you give to someone considering this product?

Data modelling

Pros

  • Enables Productivity
  • Efficient Service
  • Saves Time
  • Altruistic

Meenakshi R.

  • Role: Consultant
  • Industry: Consulting
  • Involvement: End User of Application
Validated Review
Verified Reviewer

Submitted Mar 2024

Data transformation engine

Likeliness to Recommend

8 /10

What differentiates Microsoft Power Query from other similar products?

Easy reusability of code

What is your favorite aspect of this product?

Support for various data source ingestion

What do you dislike most about this product?

Nothing at all

What recommendations would you give to someone considering this product?

Data prep and flow tool

Pros

  • Helps Innovate
  • Unique Features
  • Respectful
  • Fair

Most Popular Microsoft Power Query Comparisons