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
1
Since last award
94 Plan to Renew
1
Since last award
83 Satisfaction of Cost Relative to Value
4
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
Vendor Support
Availability and Quality of Training
Ease of Customization
Microsoft Power Query Reviews
AJAY KUMAR T.
- Role: Information Technology
- Industry: Technology
- Involvement: IT Development, Integration, and Administration
Submitted Mar 2025
Power Query is heart of Microsoft Power BI.
Likeliness to Recommend
What differentiates Microsoft Power Query from other similar products?
Microsoft Power Query is a powerful tool for importing, cleaning, and transforming data from various sources like Excel, databases, and web pages. It provides an easy-to-use, step-by-step interface that allows users to filter, merge, and modify data without writing complex code. One of its key advantages is automation, as it lets users refresh and update data effortlessly. Since it is well-integrated with Microsoft products like Excel and Power BI, it is a great choice for business users. Its user-friendly design makes data preparation simple, even for those without technical expertise.
What is your favorite aspect of this product?
My favorite thing about Power Query is how easily it cleans and transforms data without needing complex formulas or coding. It saves time by automating tasks like filtering, merging, and updating data. Plus, its smooth integration with Excel and Power BI makes data analysis much easier.
What do you dislike most about this product?
One thing I dislike about Power Query is that it can be slow when handling very large datasets. Sometimes, complex transformations take time to process, which can be frustrating. Also, its interface, while user-friendly, may feel limited compared to advanced coding tools for data manipulation.
What recommendations would you give to someone considering this product?
If you are considering Power Query, start by exploring its basic features like importing and cleaning data. It is great for automating repetitive tasks, so learn how to refresh data easily. Make sure your data sources are well-structured to avoid issues when merging or transforming them. If you work with large datasets, test performance to see if it meets your needs. Since it integrates well with Excel and Power BI, it’s perfect for business users and analysts. Watch tutorials or take online courses to get the most out of it. Finally, practice with sample data to build confidence before using it for important tasks.
Pros
- Effective Service
- Continually Improving Product
- Performance Enhancing
- Trustworthy
Please tell us why you think this review should be flagged.
Herbert D.
- Role: Information Technology
- Industry: Telecommunications
- Involvement: IT Development, Integration, and Administration
Submitted Mar 2025
I feel delighted with Power Querry.
Likeliness to Recommend
What differentiates Microsoft Power Query from other similar products?
Power Query is directly integrated withing Excel or Power BI which makes it easy to clean up date and perform data transformations. This has helped me automatize my reporting processes and reduce time for everyone.
What is your favorite aspect of this product?
That it saves the steps you create for the data cleansing and transformations. This has allowed me to create multiple automatizations for the service delivery department.
What do you dislike most about this product?
I would like to have a ctrl+z option to go back if I made a mistake. Currently there is not an option to go back.
What recommendations would you give to someone considering this product?
It involves training but the learning curve is pretty easy. I would definitely recommend it.
Pros
- Helps Innovate
- Reliable
- Performance Enhancing
- Enables Productivity
Please tell us why you think this review should be flagged.
Akshay P.
- Role: Student Academic
- Industry: Education
- Involvement: End User of Application
Submitted Mar 2025
A Comprehensive Review of Microsoft Power Query
Likeliness to Recommend
What differentiates Microsoft Power Query from other similar products?
Microsoft Power query stands out due to Seamless integration with microsoft products, user friendly interface, automated data refresh, scalability, Data transformation capabilities and cost efficient.
What is your favorite aspect of this product?
One of the best aspect of this product is its balance between ease of use and power.
What do you dislike most about this product?
Performance issue while working on large datasets and Dependency on excel and powerbi version.
What recommendations would you give to someone considering this product?
Key recommendation to maximize its efficiency is to break complex transformation into multiple steps and rename steps descriptively.
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.
