メインコンテンツまでスキップ

Discover the language

The Power Query M formula language is optimized for building highly flexible data mashup queries. It's a functional, case sensitive language similar to F#. Power Query Formula Language is used in a number of Microsoft products such as Power BI Desktop, Excel, and Analysis Services.

This site stands as a reference for Power Query functions, offering quick and direct access to detailed information and practical examples for each function.

注記

Please note, the author does not claim any copyright rights over the materials presented on this site. The information is collected and provided in the hope that it will be useful for those looking to expand their knowledge and application of Power Query.

The search functionality on this website should simplify the discovery process of the wide array of Power Query functions. Make sure you check it out (Ctrl+K).

Search functionality provided by Algolia

For those interested in deeper exploration or implementation details, further information can be found in the following GitHub repository: https://github.com/Hugoberry/powerquery-io. This repository may contain additional examples, updates, and resources relevant to Power Query development and usage.

Power Query M language specification

The specification describes the values, expressions, environments and variables, identifiers, and the evaluation model that form the Power Query M language’s basic concepts.

Power Query M language specification.pdf