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
David K.
- Role: Information Technology
- Industry: Healthcare
- Involvement: IT Development, Integration, and Administration
Submitted Feb 2025
Easy to use, but a bit pricey.
Likeliness to Recommend
What differentiates Microsoft Power Query from other similar products?
1. Seamless Integration with Microsoft Ecosystem 2. No-Code, User-Friendly Interface 3. Extensive range of connectors (100+), including databases, APIs, web pages, cloud platforms (Azure, Salesforce), and files (CSV, Excel, etc.). 4. Power Query uses query folding, which pushes transformations back to the data source (e.g., SQL databases) instead of loading all data locally.
What is your favorite aspect of this product?
One of the standout aspects of Microsoft Power Query is its automation and repeatability of data transformations. Once you’ve set up a data query with all your cleaning and transformation steps, you can save it and refresh the data anytime with a single click. This eliminates repetitive, manual work and ensures data consistency.
What do you dislike most about this product?
One of the biggest limitations of Microsoft Power Query is its performance with very large datasets. Performance can slow down significantly when dealing with millions of rows or complex transformations, especially if the data source doesn’t support query folding.
What recommendations would you give to someone considering this product?
1. Start with Clear Data Preparation Goals 2. Leverage the Integration with Excel and Power BI 3. Familiarize Yourself with Query Folding 4. Be Mindful of Performance with Large Datasets
Pros
- Reliable
- Security Protects
- Performance Enhancing
- Enables Productivity
Vipul J.
- Role: Operations
- Industry: Finance
- Involvement: Business Leader or Manager
Submitted Feb 2025
best way for consolidation of Data & saving time
Likeliness to Recommend
What differentiates Microsoft Power Query from other similar products?
Dont remember there is any tool of such nature ever introduced or exist being Power Query at its bets
What is your favorite aspect of this product?
Easier to work through and time saving (with even less tech knowledge)
What do you dislike most about this product?
It doesn't automatically refresh with added fields as you have to edit and bring back those (Ideally if there is no filtration to columns then should automatically pick up the latest structure), at time using Power Query for Sharepoint data files become nightmare
What recommendations would you give to someone considering this product?
If you are struggling by consolidating the excel files manually, Power Query is like a Super HERO
Pros
- Helps Innovate
- Continually Improving Product
- Reliable
- Performance Enhancing
- Role: Information Technology
- Industry: Technology
- Involvement: IT Development, Integration, and Administration
Submitted Dec 2024
A wonderfully robust product with a catch
Likeliness to Recommend
Pros
- Continually Improving Product
- Performance Enhancing
- Enables Productivity
- Efficient Service
Cons
- Less Friendly Negotiation
