Power Query language service for VS Code
Suggests keywords, local variables, and the standard Power Query library.
Displays function documentation if it exists, and validates the types for function arguments.
Provides a formatter for the "Format Document" (Alt + Shift + F) command.
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. There is a
These commands require one or more text selections in the active editor window.
A more specialized version of this command will extract the M Document from an entire model.json/dataflow.json document. This command requires the active document to be recognized as JSON. The result is a new PowerQuery document.
How to build
How to run command line tests
There is also a UI test suite that can be run from VS Code.
Generate vscode extension
Install the vsce CLI utility.
Generate vsix package:
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.