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
1
Since last award
94 Plan to Renew
82 Satisfaction of Cost Relative to Value
1
Since last award
Emotional Footprint Overview
- Product Experience:
- 95%
- Negotiation and Contract:
- 87%
- Conflict Resolution:
- 90%
- Strategy & Innovation:
- 90%
- Service Experience:
- 91%
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 Pre-Processing
Data Cleansing
Data Access
Data Profiling
Data Enrichment
Data Modelling Tools
Data Security
Data Packaging
Cataloging
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
Availability and Quality of Training
Vendor Support
Ease of Customization
Microsoft Power Query Reviews
Hady R.
- Role: Information Technology
- Industry: Technology
- Involvement: End User of Application
Submitted Jun 2022
In order to prepare and transform data.
Likeliness to Recommend
What differentiates Microsoft Power Query from other similar products?
You can manipulate the data to suit your needs while keeping the original source intact. To achieve a single view of your data, you can shape it by combining information from multiple sources. You can finish the query and export it to a spreadsheet or data model.
What is your favorite aspect of this product?
I like Microsoft Power Query allows you to collect and model data. To meet your analysis needs, it allows you to link, merge, and modify data sources. You can import data from the cloud, a service, or locally and make connections to it.
What do you dislike most about this product?
I have no issues with Microsoft Power Query; it is a tool that consolidates, transforms, enriches, standardizes, and adjusts your data so that it can be studied effectively.
What recommendations would you give to someone considering this product?
To produce charts and reports, I recommend using Microsoft Power Query to import the query into Excel. Extract, transform, and load (ETL) data processing is possible. It provides access to a diverse set of data sources, including data of various shapes and sizes.
Pros
- Helps Innovate
- Continually Improving Product
- Reliable
- Performance Enhancing
Please tell us why you think this review should be flagged.
Taufik R.
- Role: Information Technology
- Industry: Technology
- Involvement: End User of Application
Submitted Jun 2022
Collaborate and shape your data.
Likeliness to Recommend
What differentiates Microsoft Power Query from other similar products?
Power Query can import data into a single data source, such as an Excel document, or multiple databases, sources, or cloud services. You can use Power Query to combine all those data sources, as well as your own custom joins and transformations, to discover new insights. From the external data source, you can update the data with additions, changes, and deletions.
What is your favorite aspect of this product?
I like Microsoft Power Query is a tool that helps: Create a one-of-a-kind tabular form to meet your data analysis requirements. External data can be imported or connected. You can use Excel to produce charts and reports based on the query. You can remove a column, change a data type, and filter the rows.
What do you dislike most about this product?
For those who aren't familiar with Excel, Microsoft Power Query has a steep learning curve.
What recommendations would you give to someone considering this product?
I recommend Microsoft Power Query as it allows you to: Track everything you do with your data by capturing and labeling each transformation or step you apply to your data. By adding or combining many queries in an Excel workbook, you can combine them. The query options dialog allows you to change the load options.
Pros
- Helps Innovate
- Continually Improving Product
- Reliable
- Performance Enhancing
Please tell us why you think this review should be flagged.
Andrew S.
- Role: Information Technology
- Industry: Technology
- Involvement: End User of Application
Submitted Jun 2022
Preparing and transforming data
Likeliness to Recommend
What differentiates Microsoft Power Query from other similar products?
Extract, transform, and load ETL data processing is possible. Data from various sources, shapes, and sizes can be connected. You can organize the data to be processed and analyzed. It allows you to develop database transformations and connectors, as well as share them. Data can be obtained from a variety of sources, including Excel documents.
What is your favorite aspect of this product?
I like Microsoft Power Query. To process large volumes of data. It allows the loading and transformation of data. Data can be imported from a variety of sources, including Excel, CSV, SharePoint, SQL, and Salesforce. It is possible to clean and convert messy data into well-tabulated data. You can load data, change parameters, and perform simple transformations on rows or columns.
What do you dislike most about this product?
Power Query is different from traditional Excel work in terms of data extraction and manipulation, so users need to be trained and educated on how to use it.
What recommendations would you give to someone considering this product?
I propose to use Microsoft Power Query to communicate the results or make reports with the data. It allows you to connect the plugin to any data source.
Pros
- Helps Innovate
- Continually Improving Product
- Reliable
- Performance Enhancing
Please tell us why you think this review should be flagged.
Get Instant Access<br>to this Report
Get Instant Access
to this Report
Unlock your first report with just a business email. Register to access our entire library.
© 2025 SoftwareReviews.com. All rights reserved.
