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.
89 Likeliness to Recommend
1
Since last award
94 Plan to Renew
82 Satisfaction of Cost Relative to Value
1
Since last award
Emotional Footprint Overview
- Product Experience:
- 95%
- Negotiation and Contract:
- 87%
- Conflict Resolution:
- 90%
- Strategy & Innovation:
- 90%
- Service Experience:
- 91%
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 Enrichment
Data Modelling Tools
Data Security
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
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.
Shantanu B.
- Role: Operations
- Industry: Retail
- Involvement: Vendor Selection and Purchasing
Submitted Apr 2023
Better support for Data
Likeliness to Recommend
What differentiates Microsoft Power Query from other similar products?
1. Seamless integration with Microsoft Excel: Power Query is a part of the Microsoft Excel suite of tools, which means that it integrates seamlessly with Excel. This makes it easy for Excel users to use Power Query without having to learn a new tool. 2. Wide variety of data sources: Power Query supports a wide variety of data sources, including relational databases, CSV files, Excel files, and web-based data sources. This makes it a versatile tool that can be used to work with many different types of data. 3. Intuitive user interface: Power Query has an intuitive user interface that allows users to easily transform and clean data.
What is your favorite aspect of this product?
Microsoft Power Query stands out from other similar products due to its user-friendly interface, flexibility, and powerful data transformation capabilities. Integration with Microsoft Excel and Power BI: Power Query is a built-in feature of Microsoft Excel and Power BI, which makes it easy for users to import, transform, and analyze data directly within these popular tools
What do you dislike most about this product?
1. Steep learning curve: Some users have found that Power Query has a steep learning curve, particularly if they are new to data transformation or programming. 2. Performance issues with large datasets: Power Query can be slow when working with very large datasets, particularly if the data is stored in remote sources. 3. Limited debugging options: When an error occurs in Power Query, it can be difficult to debug and troubleshoot the issue, particularly for users who are not familiar with programming.
What recommendations would you give to someone considering this product?
1. Take advantage of available resources: Microsoft offers a wealth of resources to help users get started with Power Query, including documentation, online tutorials, and forums where users can ask questions and get help from the community. 2. Start small and work your way up: Power Query can be overwhelming at first, so it's a good idea to start with simple tasks and gradually work your way up to more complex transformations. 3. Learn some basic programming concepts: While you don't need to be a programmer to use Power Query, having a basic understanding of programming concepts like functions, variables, and conditional statements.
Pros
- Helps Innovate
- Enables Productivity
- Inspires Innovation
- Generous Negotitation
Cons
- Wastes Time
Please tell us why you think this review should be flagged.
Amr A.
- Role: Student Academic
- Industry: Education
- Involvement: End User of Application
Submitted Jan 2023
Innovative Data Query Solution.
Likeliness to Recommend
What differentiates Microsoft Power Query from other similar products?
It is innovative and adds business value and advanced data analysis capabilities to one of the world's most used applications ( Microsoft Excel )
What is your favorite aspect of this product?
Microsoft Power Query is an efficient data query engine that allows for advanced data ETL operation, and analytical capabilities within Microsoft Excel, Power BI, and many data applications.
What do you dislike most about this product?
Microsoft Power Query implementation methods confusingly vary across applications. And it's not available for all versions of a single application, like Excel versions before 2016.
What recommendations would you give to someone considering this product?
It would be great to spend some time reading the official documentation to learn about product compatibility and integrations with other data analytics applications.
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.
