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
95 Plan to Renew
83 Satisfaction of Cost Relative to Value
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.
+92 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 Cleansing
Data Connectors and Data Mashup
Data Pre-Processing
Data Modelling Tools
Data Access
Data Security
Data Profiling
Data Enrichment
Data Packaging
Collaboration
Vendor Capability Ratings
Business Value Created
Ease of Data Integration
Ease of Implementation
Quality of Features
Breadth 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
Kevin M.
- Role: Finance
- Industry: Finance
- Involvement: Business Leader or Manager
Submitted Feb 2025
Power Query is a powerful ETL tool for business
Likeliness to Recommend
What differentiates Microsoft Power Query from other similar products?
It allows the user to connect to various data sources such as Excel tables, databases and web pages.
What is your favorite aspect of this product?
It's clean, merge, append and groups data easily
What do you dislike most about this product?
Complex in understanding its data source
What recommendations would you give to someone considering this product?
Enable the Power Query data profiling tools to easily discover info about your data
Pros
- Continually Improving Product
- Performance Enhancing
- Enables Productivity
- Trustworthy
Mayank S.
- Role: Information Technology
- Industry: Technology
- Involvement: End User of Application
Submitted Mar 2025
Worth tool for data automating tasks
Likeliness to Recommend
What differentiates Microsoft Power Query from other similar products?
Microsoft Power Query stands out from other similar tools due to its seamless integration with Excel and Power BI, making it highly accessible for users familiar with Microsoft’s ecosystem.
What is your favorite aspect of this product?
its seamless integration with Excel and Power BI, making it an excellent tool for professionals who frequently work with data but don’t want to write complex code. The user-friendly interface, combined with the option to use M Language for advanced transformations, makes it flexible for both beginners and experienced users
What do you dislike most about this product?
limited compatibility with non-Microsoft software, and unclear error messages that make debugging difficult.
What recommendations would you give to someone considering this product?
If you use Excel or Power BI, Power Query is a great choice for automating data tasks
Pros
- Effective Service
- Includes Product Enhancements
- Friendly Negotiation
- Continually Improving Product
Franklin O.
- Role: Information Technology
- Industry: Technology
- Involvement: IT Leader or Manager
Submitted Feb 2025
Efficient and valuable. Pricing requires attention
Likeliness to Recommend
What differentiates Microsoft Power Query from other similar products?
The ease of integration and use amongst staff sets it apart. Also, power query increases efficiency and it is also very ease to understand and implement.
What is your favorite aspect of this product?
My favourite aspect of power query is the data import and transformation commands. This features allows for ease data cleansing.
What do you dislike most about this product?
I dislike the difficult in implementing the M language using logical test.
What recommendations would you give to someone considering this product?
I would recommend the use of power query if speed and data security is the aim.
Pros
- Continually Improving Product
- Reliable
- Performance Enhancing
- Enables Productivity
