Power Query language service for VS Code

Available in the Visual Studio Code Marketplace. Provides a language service for the Power Query / M formula language with the following capabilities:

Fuzzy autocomplete

Suggests keywords, local variables, and the standard Power Query library.

Hover

Function hints

Displays function documentation if it exists, and validates the types for function arguments.

Code formatting

Provides a formatter for the "Format Document" (Alt + Shift + F) command.

Commands

String encoding/decoding

These commands can be used to add/remove M and JSON string formatting to/from the currently selected text. This can be helpful when you need to encode an embedded SQL (or other) query in an M expression, or when you're working with files that contain embedded M expressions, such as Power BI Dataflow's model.json file, and Power Query traces.

These commands require one or more text selections in the active editor window.

Related projects

• powerquery-parser: A lexer + parser for Power Query. Also contains features such as type validation.
• powerquery-formatter: A code formatter for Power Query which is bundled in the VSCode extension.
• powerquery-language-services: A high level library that wraps the parser for external projects, such as the VSCode extension. Includes features such as Intellisense.

How to build

1. install dependencies:

npm install

2. build all packages:

npm run build

How to run command line tests

cd server
npm run test

There is also a UI test suite that can be run from VS Code.

Generate vscode extension

Install the vsce CLI utility.

npm install --global vsce

Generate vsix package:

vsce package

Contributing

This project welcomes contributions and suggestions. Most contributions require you to agree to a Contributor License Agreement (CLA) declaring that you have the right to, and actually do, grant us the rights to use your contribution. For details, visit https://cla.microsoft.com.

When you submit a pull request, a CLA-bot will automatically determine whether you need to provide a CLA and decorate the PR appropriately (e.g., label, comment). Simply follow the instructions provided by the bot. You will only need to do this once across all repos using our CLA.

This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact opencode@microsoft.com with any additional questions or comments.