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

Microsoft Power Query

8.5 /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.

89 Likeliness to Recommend

95 Plan to Renew

86 Satisfaction of Cost Relative to Value

1
Since last award


{y}
{name}

Emotional Footprint Overview

+93 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?

2% Negative
5% Neutral
93% Positive

Pros

  • Reliable
  • Trustworthy
  • Helps Innovate
  • Continually Improving Product

Feature Ratings

Average 85

Data Integration

88

Data Connectors and Data Mashup

87

Data Profiling

86

Data Pre-Processing

85

Data Enrichment

85

Data Access

84

Cataloging

83

Data Cleansing

83

Data Packaging

83

Data Modelling Tools

80

Vendor Capability Ratings

Average 82

Ease of Data Integration

85

Business Value Created

85

Ease of Implementation

84

Breadth of Features

82

Availability and Quality of Training

82

Usability and Intuitiveness

82

Vendor Support

82

Ease of IT Administration

82

Product Strategy and Rate of Improvement

81

Quality of Features

81

Ease of Customization

79

Microsoft Power Query Reviews

Arpita N.

  • Role: Operations
  • Industry: Food and Beverage
  • Involvement: Initial Implementation
Validated Review
Verified Reviewer

Submitted Oct 2024

"Microsoft Power Query: Powerful Data."

Likeliness to Recommend

9 /10

What differentiates Microsoft Power Query from other similar products?

Microsoft Power Query stands out due to its seamless integration with Microsoft Excel and Power BI, user-friendly interface, and robust data transformation capabilities. Its support for a wide range of data sources and the ability to create custom functions further differentiate it from competitors, making it accessible for both novice and advanced users.

What is your favorite aspect of this product?

My favorite aspect of Microsoft Power Query is its intuitive user interface, which makes complex data transformations accessible even for users with limited technical skills. The ability to easily connect to various data sources and perform advanced transformations enhances productivity significantly.

What do you dislike most about this product?

The aspect I dislike most about Microsoft Power Query is its sometimes-limited error handling, which can make troubleshooting data issues frustrating. Additionally, performance can lag with very large datasets, impacting efficiency during data processing.

What recommendations would you give to someone considering this product?

Microsoft Power Query simplifies data transformation with its intuitive interface and wide integration options. It’s efficient for automating tasks and works well with various data sources, making it a valuable tool for data analysis.

Pros

  • Reliable
  • Trustworthy
  • Unique Features
  • Efficient Service

Chris M.

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

Submitted Sep 2024

The Best way of data preparation

Likeliness to Recommend

9 /10

What differentiates Microsoft Power Query from other similar products?

Its seamless integration with all Microsoft software without demanding any additional needs, thus providing an eco-friendly environment to its users. It also facilitates a user-friendly interface without requiring any coding skills, unlike its similar products, which demand high coding expertise. These features make them stand out in the market.

What is your favorite aspect of this product?

Its capability of a no-code interface combined with powerful transformation is the best thing in it. Its drag-and-drop interface assists a lot during the management of data sets like cleaning, transforming and creating a confirmed environment for those who don't have much expertise in it. Along with these, it also facilitates its us with advanced language features such as M language which helps in dealing with complex transformation.

What do you dislike most about this product?

I really like the way this tool is providing amazing services. It is a very powerful software and can handle data in a very efficient way, however, sometimes, when the amount of data is too high to handle and is taking a complex shape, it shows slow functioning and unresponsiveness. This somehow becomes a hurdle in the accomplishment of tasks and this needs to be considered. Other than this, it is complementing well with my activities.

What recommendations would you give to someone considering this product?

For someone considering this, should go for it if they want solution for their data management.

Pros

  • Reliable
  • Saves Time
  • Respectful
  • Altruistic

Dishank S.

  • Role: Operations
  • Industry: Manufacturing
  • Involvement: IT Development, Integration, and Administration
Validated Review
Verified Reviewer

Submitted Sep 2024

Good Product

Likeliness to Recommend

9 /10

What differentiates Microsoft Power Query from other similar products?

Power Query automates repetitive tasks, saving time compared to other tools & Power Query integrates with other Microsoft Office tools, such as Excel and Power BI.

What is your favorite aspect of this product?

My favorite aspect for this product is that it is able to Combining Multiple Tables. Combining Multiple Files. Connection to Central Data Sources, import or connect to external data, and then shape that data,

What do you dislike most about this product?

Although Power Query is user-friendly, it take some time to learn the interface and the various transformation options. also the Query names cannot contain double quotes, periods, or leading or trailing whitespaces.

What recommendations would you give to someone considering this product?

I suggest to do research regarding other products also for your type of industries & then select wisely.

Pros

  • Reliable
  • Performance Enhancing
  • Enables Productivity
  • Trustworthy

Most Popular Microsoft Power Query Comparisons