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.
+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 Cleansing
Data Pre-Processing
Data Modelling Tools
Data Access
Data Profiling
Data Security
Data Enrichment
Data Packaging
Intelligent Alerts and Notifications
Vendor Capability Ratings
Business Value Created
Ease of Data Integration
Ease of Implementation
Quality of Features
Breadth of Features
Usability and Intuitiveness
Product Strategy and Rate of Improvement
Ease of IT Administration
Vendor Support
Availability and Quality of Training
Ease of Customization
Microsoft Power Query Reviews
Heena O.
- Role: Information Technology
- Industry: Other
- Involvement: IT Development, Integration, and Administration
Submitted Nov 2023
Should Have this product
Likeliness to Recommend
What differentiates Microsoft Power Query from other similar products?
Power Query's deep integration with widely used Microsoft applications, User-Friendly Interface, and its robust capabilities
What is your favorite aspect of this product?
Advanced Transformation Capabilities , Data Source Connectivity , M Language , handle large datasets efficiently
What do you dislike most about this product?
Performance Issues particularly when dealing with very large datasets or complex transformations
What recommendations would you give to someone considering this product?
Based on ecosystem around Power Query, you can make an informed decision on whether it's the right investment for your data transformation and analysis needs within the Microsoft environment
Pros
- Reliable
- Helps Innovate
- Performance Enhancing
- Enables Productivity
RAHUL G.
- Role: Information Technology
- Industry: Technology
- Involvement: IT Development, Integration, and Administration
Submitted Nov 2023
Best business intelligence tools language
Likeliness to Recommend
What differentiates Microsoft Power Query from other similar products?
Microsoft Power Query Editor is one of the most powerful platform for cleaning the dirty data, it can handle n numbers of transformation very easily.
What is your favorite aspect of this product?
Creating Calculated columns using DAX is one of the most important feature of power query.
What do you dislike most about this product?
It require a system with high specs or else the Power BI desktop application gets slow to create data transformation and cleaning on Power Query.
What recommendations would you give to someone considering this product?
One of the best platform to clean the ambiguity in dirty data, we just need to know the DAX code for better customisation.
Faisal S.
- Role: Sales Marketing
- Industry: Healthcare
- Involvement: IT Development, Integration, and Administration
Submitted Nov 2023
Fantastic Tool
Likeliness to Recommend
What differentiates Microsoft Power Query from other similar products?
best data modules with easy eye catching result
What is your favorite aspect of this product?
Ease and user friendly
What do you dislike most about this product?
nothing to find any disliking feature
What recommendations would you give to someone considering this product?
this tool is very effective to drive your data with easy transformation
Pros
- Continually Improving Product
- Trustworthy
- Inspires Innovation
- Caring
