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 AssistanceMicrosoft 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
94 Plan to Renew
82 Satisfaction of Cost Relative to Value
1
Since last award
Emotional Footprint Overview
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.
+91 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?
Pros
- Reliable
- Performance Enhancing
- Helps Innovate
- Enables Productivity
How to read the Emotional Footprint
The Net Emotional Footprint measures high-level user sentiment towards particular product offerings. It aggregates emotional response ratings for various dimensions of the vendor-client relationship and product effectiveness, creating a powerful indicator of overall user feeling toward the vendor and product.
While purchasing decisions shouldn't be based on emotion, it's valuable to know what kind of emotional response the vendor you're considering elicits from their users.
Footprint
Negative
Neutral
Positive
Feature Ratings
Data Integration
Data Connectors and Data Mashup
Data Pre-Processing
Data Cleansing
Data Access
Data Profiling
Data Security
Data Modelling Tools
Data Enrichment
Data Packaging
Cataloging
Vendor Capability Ratings
Business Value Created
Ease of Data Integration
Ease of Implementation
Breadth of Features
Quality of Features
Usability and Intuitiveness
Ease of IT Administration
Product Strategy and Rate of Improvement
Availability and Quality of Training
Vendor Support
Ease of Customization
Microsoft Power Query Reviews
Bharti K.
- Role: Finance
- Industry: Finance
- Involvement: Business Leader or Manager
Submitted Mar 2024
Powerful tool for data preparation
Likeliness to Recommend
What differentiates Microsoft Power Query from other similar products?
Microsoft Power Query stands out from other similar products due to its seamless integration with Microsoft Excel and other Microsoft Office applications. This integration allows users to easily import, transform, and analyze data within familiar interfaces, making it accessible to a wide range of users. Additionally, Power Query's intuitive interface and powerful transformation capabilities set it apart, enabling users to perform complex data manipulations with ease.
What is your favorite aspect of this product?
My favorite aspect of Microsoft Power Query is its ability to simplify and streamline the process of data preparation. Its intuitive interface and powerful transformation capabilities make it easy to clean, transform, and manipulate data from various sources. Additionally, its integration with Microsoft Excel and other Office applications allows for seamless data analysis and reporting, making it a valuable tool for data professionals.
What do you dislike most about this product?
One aspect of Microsoft Power Query that can be challenging is the learning curve for users who are new to data transformation and manipulation. While the tool is intuitive for basic tasks, more complex transformations may require a deeper understanding of Power Query's functionalities and M language. Additionally, troubleshooting errors in data transformations can sometimes be time-consuming.
What recommendations would you give to someone considering this product?
For someone considering Microsoft Power Query, I would recommend taking advantage of the tool's built-in tutorials and documentation to familiarize yourself with its capabilities. Start with simple data transformation tasks to get comfortable with the interface and gradually explore more advanced features. Additionally, consider joining online communities or forums to learn from others' experiences and get tips for optimizing your use of Power Query.
Pros
- Helps Innovate
- Continually Improving Product
- Reliable
- Performance Enhancing
Please tell us why you think this review should be flagged.
Heena O.
- Role: Information Technology
- Industry: Other
- Involvement: IT Development, Integration, and Administration
Submitted Nov 2023
Should Have this product
Likeliness to Recommend
What differentiates Microsoft Power Query from other similar products?
Power Query's deep integration with widely used Microsoft applications, User-Friendly Interface, and its robust capabilities
What is your favorite aspect of this product?
Advanced Transformation Capabilities , Data Source Connectivity , M Language , handle large datasets efficiently
What do you dislike most about this product?
Performance Issues particularly when dealing with very large datasets or complex transformations
What recommendations would you give to someone considering this product?
Based on ecosystem around Power Query, you can make an informed decision on whether it's the right investment for your data transformation and analysis needs within the Microsoft environment
Pros
- Reliable
- Helps Innovate
- Performance Enhancing
- Enables Productivity
Please tell us why you think this review should be flagged.
Karan B.
- Role: Consultant
- Industry: Banking
- Involvement: IT Development, Integration, and Administration
Submitted Jun 2023
Time Saver
Likeliness to Recommend
What differentiates Microsoft Power Query from other similar products?
Transformation capabilities within excel. It makes it easy to implement functions like filtering, joining, aggregating, splitting, etc.
What is your favorite aspect of this product?
Statistical summaries can be seen on the whole dataset, Very good at profiling large datasets with ease and help in optimizing the cleaning strategy as anomalies can be easily detected.
What do you dislike most about this product?
As with other products of Microsoft like Power BI and Excel, power query's availability on other platforms is not available.
What recommendations would you give to someone considering this product?
Definitely go for learning this. No need to know or implement complex formulas to do tasks in excel as using power query will make it pretty easy.
Pros
- Helps Innovate
- Continually Improving Product
- Reliable
- Performance Enhancing
Please tell us why you think this review should be flagged.
Get Instant Access<br>to this Report
Get Instant Access
to this Report
Unlock your first report with just a business email. Register to access our entire library.
© 2025 SoftwareReviews.com. All rights reserved.
