G2 Vendor Directory

Power Query

by Microsoft

17

Reviews

4.5

Star rating

#42

Rank in ETL Tools

Pros and cons

Pros

  • Time-saving
  • Intuitive
  • Simple
  • Solution Efficiency
  • Automation
  • Ease of Use

Cons

  • Lack of Real-Time Data
  • Refresh Issues

Traffic & LLM citations

Monthly G2.com page views and citations by AI answer engines for Power Query.

Page views and citations · Power Query

Source: G2 review data

Losing to

Based on reviewers of other products who said they switched from Power Query.

Key stats

—

59

Mid-Market

1

Adoption by company size

SegmentShare of reviews
Small Business29.4%
Mid-Market52.9%
Enterprise17.6%

Quarterly history

QuarterReviewsStar rating
2026 Q114.0

Satisfaction ratings

Ease of Use9.1
Ease of Setup8.8
Quality of Support8.8
Meets Requirements8.8

What reviewers say

Effortless Data Cleaning with Power Query's Intuitive Interface

4.0

“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 tur”

Apprentice

Best data transformation and preparation tool

5.0

“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.”

Full stack developer

Power Query Explained

3.0

“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 y”

Product Associate