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
96 Plan to Renew
82 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.
+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
- Performance Enhancing
- Enables Productivity
- Fair
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 Pre-Processing
Record Deduplication
Data Connectors and Data Mashup
Data Profiling
Data Access
Data Modelling Tools
Data Security & Masking
Data Enrichment
Data Preparation Workflow
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
Ease of Customization
Availability and Quality of Training
Microsoft Power Query Reviews
Dishank S.
- Role: Operations
- Industry: Manufacturing
- Involvement: IT Development, Integration, and Administration
Submitted Sep 2024
Good Product
Likeliness to Recommend
What differentiates Microsoft Power Query from other similar products?
Power Query automates repetitive tasks, saving time compared to other tools & Power Query integrates with other Microsoft Office tools, such as Excel and Power BI.
What is your favorite aspect of this product?
My favorite aspect for this product is that it is able to Combining Multiple Tables. Combining Multiple Files. Connection to Central Data Sources, import or connect to external data, and then shape that data,
What do you dislike most about this product?
Although Power Query is user-friendly, it take some time to learn the interface and the various transformation options. also the Query names cannot contain double quotes, periods, or leading or trailing whitespaces.
What recommendations would you give to someone considering this product?
I suggest to do research regarding other products also for your type of industries & then select wisely.
Pros
- Reliable
- Performance Enhancing
- Enables Productivity
- Trustworthy
Kareem O.
- Role: Finance
- Industry: Food and Beverage
- Involvement: End User of Application
Submitted Aug 2024
Great Product
Likeliness to Recommend
What differentiates Microsoft Power Query from other similar products?
Power Query is deeply integrated with Microsoft tools such as Excel, Power BI, and Microsoft Azure, allowing for a cohesive and streamlined data preparation process across these platforms. This integration facilitates easy data import, transformation, and analysis within a familiar environment. **2. User-Friendly Interface
What is your favorite aspect of this product?
My favorite aspect of Microsoft Power Query is its user-friendly interface combined with powerful data transformation capabilities.
What do you dislike most about this product?
The main drawback of Microsoft Power Query is its limited support for real-time data streaming. While it excels in transforming and preparing static datasets, it doesn't offer robust capabilities for handling continuously updated or real-time data feeds.
What recommendations would you give to someone considering this product?
Begin with straightforward data transformation tasks to get a feel for Power Query’s functionality. As you become more comfortable, gradually tackle more complex data preparation projects.
Pros
- Altruistic
- Helps Innovate
- Reliable
- Performance Enhancing
Rajiv k.
- Role: Information Technology
- Industry: Education
- Involvement: IT Leader or Manager
Submitted Mar 2026
Best tool to analytical data analysis on platform
Likeliness to Recommend
What differentiates Microsoft Power Query from other similar products?
Basically I was using internal tools to show dashboard but it is not upto the mark so we implement this tool to get the data into dashboards like how much sales happens as well as margin between them as well as transaction history and analysis of refund and adjusting amounts which comes to us and what is happening in sales like orders are coming or not and from which areas is coming like location of person so we can run the ads their to bring more business as well
What is your favorite aspect of this product?
Best part is the data connector which automatically refreshes so we don't need the data to put again and again as well as easy dashboard view with filtration inside it
What do you dislike most about this product?
Nothing everything is fine from my side
What recommendations would you give to someone considering this product?
Best product to analysis of user as well as sales analytics with knowing about the activity of orders so you can hit back to that location with retargeting of products as well
Pros
- Helps Innovate
- Reliable
- Enables Productivity
- Unique Features
