What is Microsoft Power Query?
Power Query is the easiest way to connect, extract, transform and load data from a wide range of sources.
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.
88 Likeliness to Recommend
1
Since last award
97 Plan to Renew
87 Satisfaction of Cost Relative to Value
1
Since last award
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?
Pros
- Reliable
- Fair
- Helps Innovate
- Trustworthy
Emotional Footprint
How to Read
Positive
Neutral
Negative
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
Feature Ratings
Data Integration
Data Connectors and Data Mashup
Data Enrichment
Data Profiling
Data Pre-Processing
Data Access
Data Cleansing
Cataloging
Data Packaging
Data Modelling Tools
Vendor Capability Ratings
Ease of Data Integration
Ease of Implementation
Business Value Created
Ease of IT Administration
Quality of Features
Usability and Intuitiveness
Product Strategy and Rate of Improvement
Breadth of Features
Availability and Quality of Training
Vendor Support
Ease of Customization
Microsoft Power Query Reviews
Ravi Shekhar P.
- Role: Consultant
- Industry: Transportation
- Involvement: IT Leader or Manager
Submitted Oct 2021
Easy to learn and use
Likeliness to Recommend
What differentiates Microsoft Power Query from other similar products?
Easy to learn and use
What is your favorite aspect of this product?
Easy to learn and use
What do you dislike most about this product?
Less features
What recommendations would you give to someone considering this product?
It is very Easy to learn and use as it comes prebuilt in ms office.
Pros
- Reliable
- Saves Time
- Helps Innovate
- Continually Improving Product
Dustin A.
- Role: Information Technology
- Industry: Consulting
- Involvement: IT Development, Integration, and Administration
Submitted Mar 2021
Simplifying your data discovery
Likeliness to Recommend
What differentiates Microsoft Power Query from other similar products?
I like how Microsoft Power Query offers a wide range of data transformation that you only need to click (yes no need to code!) without making it hard to use even for non IT people.
What is your favorite aspect of this product?
Microsoft Power Query offers a lot of capabilities in order for you to transform your data into a presentable way, if offers a wide range of data source connection and joining multiple data sources, adding a calculated column, executing python or sql scripts and anything you can imagine.
What do you dislike most about this product?
Nothing. Seriously, I've been handling the tool for 5 years but the tool keeps getting awesome and awesome since they always update.
What recommendations would you give to someone considering this product?
If you are using an Excel for your company's reporting tool then I would suggest to add Microsoft Power Query which will help you transform your data so you can easily visualize and present it or you can use Power BI Desktop which also uses Power Query. It also helps to automate your reporting task which you can utilize to save some time.
Pros
- Helps Innovate
- Continually Improving Product
- Reliable
- Performance Enhancing
Tyler F.
- Role: C-Level
- Industry: Healthcare
- Involvement: End User of Application
Submitted Jan 2021
Take control of your data in the best way possible
Likeliness to Recommend
What differentiates Microsoft Power Query from other similar products?
Comfortable and familiar interface with attention to overall functionality
What is your favorite aspect of this product?
Just how easy it is to get and process information
What do you dislike most about this product?
I can’t say there’s anything I don’t like
What recommendations would you give to someone considering this product?
If you’re looking to strengthen your team, time management and Analytical integrity, this one is for you!
Pros
- Reliable
- Performance Enhancing
- Enables Productivity
- Trustworthy