--- title: Power Query Reviews meta_title: 'Power Query Reviews 2026: Details, Pricing, & Features | G2' meta_description: Filter 16 reviews by the users' company size, role or industry to find out how Power Query works for a business like yours. aggregate_rating: rating_value: 4.4 review_count: 16 scale: '5' date_modified: '2026-06-17' parent_category: name: Cloud Data Integration url: https://www.g2.com/categories/cloud-data-integration --- # Power Query Reviews **Vendor:** Microsoft **Category:** [ETL Tools](https://www.g2.com/categories/etl-tools) **Average Rating:** 4.4/5.0 **Total Reviews:** 16 ## About Power Query Every company has a mission. What's ours? To empower every person and every organization to achieve more. We believe technology can and should be a force for good and that meaningful innovation contributes to a brighter world in the future and today. Our culture doesn’t just encourage curiosity; it embraces it. Each day we make progress together by showing up as our authentic selves. We show up with a learn-it-all mentality. We show up cheering on others, knowing their success doesn't diminish our own. We show up every day open to learning our own biases, changing our behavior, and inviting in differences. When we show up, we achieve more together. Microsoft operates in 190 countries and is made up of more than 220,000 passionate employees worldwide. ## Power Query Pros & Cons **What users like:** - Users love the **automation features** of Power Query, simplifying data cleaning and processing with efficiency and ease. (1 reviews) - Users find **Power Query's ease of use** remarkable, allowing effortless data cleaning and refresh with a clear process. (1 reviews) - Users find Power Query **intuitive** , allowing seamless data cleaning and consistency between Excel and Power BI. (1 reviews) - Users appreciate the **simple and user-friendly interface** of Power Query for efficient data cleaning and processing. (1 reviews) - Users appreciate the **solution efficiency** of Power Query, enabling easy data cleaning and reapplication with one click. (1 reviews) - Time-saving (1 reviews) **What users dislike:** - Users face a **lack of real-time data** as Power Query often gets stuck when refreshing from web sources like SharePoint. (1 reviews) - Users often face **refresh issues** with Power Query, particularly when retrieving data from web sources like SharePoint. (1 reviews) ## Power Query Reviews ### 1. Effortless Data Cleaning with Power Query's Intuitive Interface **Rating:** 4.0/5.0 stars **Reviewed by:** Jyotirmoy B. | Apprentice, Enterprise (> 1000 emp.) **Reviewed Date:** January 12, 2026 **What do you like best about Power Query?** Power query and clean data without making change in the source, it has clear step by step process, you can apply same data cleaning steps on some new set of data that have same architecture by just one click, by clicking refresh. You can things in the graphic interface and it turn it into code. Best thing is power query is same in excel and Power BI **What do you dislike about Power Query?** Some it gets stuck while doing a step or while refreshing data from source and it mostly in case where source is in the web i.e. Sharepoint URL **What problems is Power Query solving and how is that benefiting you?** For me it helps me process data in a define matter and it is huge help when I need to put the same process in a updated dataset, there I just change data source/refresh source. ### 2. Power Query Explained **Rating:** 3.0/5.0 stars **Reviewed by:** Sambaraju Sai C. | Product Associate, Mid-Market (51-1000 emp.) **Reviewed Date:** November 14, 2023 **What do you like best about Power Query?** Discover the game-changing capabilities of Power Query, a dynamic and flexible data manipulation tool integrated into Microsoft's renowned Power BI and Excel platforms. With its seamless connectivity to diverse data sources, you can effortlessly mold and refine your data to fit your analytics and reporting needs. **What do you dislike about Power Query?** Power Query combines seamlessly with Power BI and Excel, offering a cohesive experience for those utilizing these tools. Data manipulations carried out in Power Query can effortlessly be integrated into both Power BI reports and Excel spreadsheets **What problems is Power Query solving and how is that benefiting you?** With Power Query, users have the ability to effortlessly create repeatable and seamless data transformation workflows. The process of cleaning and arranging data is automatically saved in a query, making it a breeze to replicate the same transformations on future datasets. This guarantees a consistent and efficient data preparation process. ### 3. Data integration and analysis never been this easy and effective! **Rating:** 4.0/5.0 stars **Reviewed by:** Bashar H. | Owner , Mid-Market (51-1000 emp.) **Reviewed Date:** November 01, 2023 **What do you like best about Power Query?** Ease of use, as it provides an intuitive interface allowing users to perfirm complicated data transformation tasks with simple steps. Also connectivity to a wide range of data sources, and the support it provides to a large spectrum of data transformations such as filtering, cleaning, merging, and custom column creation. **What do you dislike about Power Query?** For some users especially those with no prior data processing experience, Power Query can initially appear overwhelming due to the wide array of functions and capabilities. **What problems is Power Query solving and how is that benefiting you?** Data integration from multiple sources. It is simple, easy to use, and effective. It saves time and costs. ### 4. Best data transformation and preparation tool **Rating:** 5.0/5.0 stars **Reviewed by:** Ajay kumar G. | Full stack developer, Information Technology and Services, Small-Business (50 or fewer emp.) **Reviewed Date:** November 26, 2023 **What do you like best about Power Query?** For these kinds of operations, Power Query offers an intuitive user interface that lets users conduct sophisticated data transformations without having to write sophisticated code. **What do you dislike about Power Query?** When errors occur during data transformation, debugging within Power Query might be challenging for users without a strong understanding of the tool. **What problems is Power Query solving and how is that benefiting you?** By eliminating duplicates, repairing data kinds, resolving errors, and formatting, it helps tidy up jumbled data. Merge tables or add data from many files or sheets to combine data from multiple sources. Splitting and parsing: To make analysis easier, divide columns containing integrated data—such as whole names or addresses—into distinct columns. Sorting and Filtering: Eliminate rows that don't match certain requirements or reorganize data according to predetermined standards. ### 5. best excel tool for working **Rating:** 5.0/5.0 stars **Reviewed by:** maryam j. | Social Media Marketing Specialist, Small-Business (50 or fewer emp.) **Reviewed Date:** October 28, 2023 **What do you like best about Power Query?** this is very easy excel sheet tool for enter all data in one software and 24/7 support system is very good **What do you dislike about Power Query?** this tool is littel bit hard to understand due to formulas and need to add more features **What problems is Power Query solving and how is that benefiting you?** use all company and organization payroll or audit report but not everyone can use without understanding some steps, ### 6. Use Power Query **Rating:** 5.0/5.0 stars **Reviewed by:** Enrique M. | ADMON, Enterprise (> 1000 emp.) **Reviewed Date:** October 30, 2023 **What do you like best about Power Query?** Ease of use: Power Query provides an intuitive graphical interface that allows users to perform data transformation tasks without the need to write code. Connectivity: It allows connection to a wide variety of data sources, including databases, CSV files, Excel files, online sources, and more. Data transformation: Power Query allows a wide range of transformations on data, such as filtering, cleaning, table merging, and creating custom columns. **What do you dislike about Power Query?** Learning curve: For some users, especially those who have no prior experience in data processing, Power Query may initially seem overwhelming due to its wide range of functions and capabilities. **What problems is Power Query solving and how is that benefiting you?** Integration of data from multiple sources. ### 7. A Worth tool to learn **Rating:** 4.5/5.0 stars **Reviewed by:** Tarannum m. | Assistant Manager, Mid-Market (51-1000 emp.) **Reviewed Date:** October 03, 2023 **What do you like best about Power Query?** It helps in Automating the tasks and can handle big data where Excel faces limitation. It is a solution oriented tool which help in Handling big data, automation and visualisation. **What do you dislike about Power Query?** There is no as such but It could have Simplicity in M-Language, It may have easier way to change the data path and It should not dependent on one system only. **What problems is Power Query solving and how is that benefiting you?** We are online e-commerce business have a good volume of data and to handle the same we need to purchase the services. ### 8. This will be a great platform to connect with mentors of our choice to upskill **Rating:** 5.0/5.0 stars **Reviewed by:** Sandeep K. | Associate Principal BIM Modeler, Enterprise (> 1000 emp.) **Reviewed Date:** November 13, 2023 **What do you like best about Power Query?** It is very ease to use, easy to search and easy to implement. **What do you dislike about Power Query?** I Didn't find any dislikes as such so far **What problems is Power Query solving and how is that benefiting you?** Power BI ### 9. If you want to combine date from multiple sources Power Query is what you need **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Accounting | Mid-Market (51-1000 emp.) **Reviewed Date:** November 15, 2023 **What do you like best about Power Query?** Power query is very helpful, you can transform the data to meet specific needs. It makes it easier and faster when woerking with it. **What do you dislike about Power Query?** If you have many excels windows open it will load slower. **What problems is Power Query solving and how is that benefiting you?** Power Query has been very helpful in our organization because it removes repetitive tasks. ### 10. Empowering data transformation **Rating:** 5.0/5.0 stars **Reviewed by:** Givaneth P. | Production Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** October 27, 2023 **What do you like best about Power Query?** its data transformation capabilities, ease of use, and integration with various data sources, making it a powerful tool for data analysis **What do you dislike about Power Query?** Personally, it's just the learning curve. **What problems is Power Query solving and how is that benefiting you?** The Manual process problem that takes a lot of time. Thru power query i can easily analyze my data. It helps me automate my spreadsheets as fast as 1 2 3 ### 11. Versatile tool for data processing **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Retail | Mid-Market (51-1000 emp.) **Reviewed Date:** October 23, 2023 **What do you like best about Power Query?** Working with several data inputs and transforming/processing it in ways Excel by itself cannot. The possibility of automating everything. **What do you dislike about Power Query?** Formula building could be simpler. There may come a point for a specific file where querys are so complex and inter-connected that loading time becomes too great and different options may need to be considered. **What problems is Power Query solving and how is that benefiting you?** Data integration and processing. Business reporting. ### 12. Power Query Useful Tool **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Non-Profit Organization Management | Mid-Market (51-1000 emp.) **Reviewed Date:** October 18, 2023 **What do you like best about Power Query?** Tasks are not repetitive. The greatest advantage of Power Query is, that I don't have to re-write/re-perform the same tasks of data operations after an interval of time. It is user-friendly and saves me a lot of time. **What do you dislike about Power Query?** It is slow when I use large datasets. It has limited compatibility with other software. **What problems is Power Query solving and how is that benefiting you?** Data analysis and business intelligence. ### 13. A good experience **Rating:** 4.5/5.0 stars **Reviewed by:** Jorge S. | electromechanical supervisor, Small-Business (50 or fewer emp.) **Reviewed Date:** October 20, 2023 **What do you like best about Power Query?** The tool is easy to use and dynamic, good for companies. **What do you dislike about Power Query?** Requires a lot of effort to process the information and adapt it to small data sets **What problems is Power Query solving and how is that benefiting you?** It offers intuitive tools for both exploring and presenting data. ### 14. ETL tool allows users to Extract, transform and load from various sources into Power BI **Rating:** 4.5/5.0 stars **Reviewed by:** Tushar G. | Senior Associate, Small-Business (50 or fewer emp.) **Reviewed Date:** October 17, 2023 **What do you like best about Power Query?** It is a powerful tool for Data preparation and analysis. **What do you dislike about Power Query?** Nothing as of now everything is good. Very good experience as of now. **What problems is Power Query solving and how is that benefiting you?** It's solve my data integration process. Data analysis and data preparation process. ### 15. Easy **Rating:** 4.5/5.0 stars **Reviewed by:** Jorge C. | Small-Business (50 or fewer emp.) **Reviewed Date:** October 12, 2023 **What do you like best about Power Query?** Is the best app to make querys on the systems **What do you dislike about Power Query?** sometimes is very complicated to make the connections **What problems is Power Query solving and how is that benefiting you?** in the process ETL ### 16. Power Query -Great for learning **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** October 22, 2023 **What do you like best about Power Query?** Combilne files and storing data from multiple source.Good functionality,Exellent for data and billing management. **What do you dislike about Power Query?** Difficult to use when applies multiple formula. **What problems is Power Query solving and how is that benefiting you?** It have many powefull features for the data interpretation. - [View Power Query pricing details and edition comparison](https://www.g2.com/products/power-query/reviews?section=pricing&secure%5Bexpires_at%5D=2026-06-23+20%3A52%3A28+-0500&secure%5Bsession_id%5D=6323c01b-ea9f-43f8-a0ef-398da6cdaf51&secure%5Btoken%5D=4b6e7455e9f170010505519ce17c3909adf209ef8987f0dd8ff806f5e24c538b&format=llm_user) ## Power Query Integrations - [Microsoft Excel](https://www.g2.com/products/microsoft-excel/reviews) - [Microsoft Power BI](https://www.g2.com/products/microsoft-microsoft-power-bi/reviews) ## Power Query Features **Management** - Reporting - Auditing **Functionality** - Extraction - Transformation - Loading - Automation - Scalability ## Top Power Query Alternatives - [Google Cloud BigQuery](https://www.g2.com/products/google-cloud-bigquery/reviews) - 4.5/5.0 (1,147 reviews) - [Databricks](https://www.g2.com/products/databricks/reviews) - 4.6/5.0 (1,284 reviews) - [Alteryx](https://www.g2.com/products/alteryx/reviews) - 4.6/5.0 (804 reviews)