pqm.guide

What It Is

PQM.guide is a community-driven reference site for the Power Query M language. Its main goal is to make it easier for users to find and understand M functions. The scraped text indicates that it provides searchable access to 661 functions, organized into categories such as Accessing Data, Table, List, Text, Date, and Value. It is not just a function index: it also offers sections like Start Here, Concepts, Patterns, and Sample Tables, making it useful both for beginners and for users solving specific data-processing problems.

Core Features and Ecosystem

In terms of functionality, PQM.guide covers a large number of M functions. The Table category alone shows 131 functions, while categories such as List, Date, and Number also appear fairly comprehensive. The site supports Ctrl+K search, allowing users to locate functions by name or description. Its Patterns page provides more business-oriented recipes, such as joins, pagination, fuzzy matching, and API Authentication examples for Web.Contents. These examples show how to pass fields such as Headers, Query, Content, RelativePath, and ManualStatusHandling through an options record. This is practical for scenarios in Power BI Service involving dynamic endpoints, authenticated requests, and avoiding hardcoded keys. In terms of language support, the text only shows Power Query M, mainly serving the Power Query, Power BI, and Excel data-processing ecosystem.

Pricing, Openness, and Documentation Quality

The scraped content does not show any paid plans, account system, or payment methods, so it can be regarded as a publicly available free reference site, though whether it has a commercial model is unclear. There is also no clear information about whether it is open source or closed source, or whether self-hosting is available. In terms of documentation quality, the site is clearly structured, with function categories, search, learning paths, concepts, and practical patterns. The “Recently Edited” section suggests that the content is being maintained. The downside is that the current text does not confirm whether each function page includes complete signatures, edge cases, version differences, and error examples. MCP Server appears in the navigation, but details about its capabilities are insufficient.

Pros, Cons, and Who It’s For

Its strengths are its focused positioning, efficient search, broad coverage, and the way it connects abstract functions with real-world data-processing patterns. Its weaknesses are the lack of information about official support, open-source status, offline/self-hosted use, and service-level support. It is suitable for Power BI/Excel data analysts, BI developers, and users who need to write M queries or call REST APIs. If authoritative version notes are required, it should still be used alongside the official Microsoft Learn documentation.

Access from China

The scraped text does not make it possible to determine availability from mainland China, loading speed, or whether the site depends on restricted resources, so china_access is marked as unknown. There is no paid access information. Alternatives include the Microsoft Learn Power Query M reference, the Power BI community, and related GitHub example repositories.