Power Query language service for VS CodeAvailable in the Visual Studio Code Marketplace. Provides a language service for the Power Query / M formula language with the following capabilities: Fuzzy autocompleteSuggests keywords, local variables, and the standard Power Query library. HoverFunction hintsDisplays function documentation if it exists, and validates the types for function arguments. Code formattingProvides a formatter for the "Format Document" (Alt + Shift + F) command. CommandsString encoding/decodingThese 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.
Related projects
How to buildInstall dependencies:
Build the project:
Generate vsix package:
The .vsix can be installed into VS Code from the commandline:
TestingThere are two test suites:
Running tests from the command lineTo run all tests:
To run server unit tests only:
Running tests from VS CodeRun one of the following Debug/Launch profiles:
ContributingThis 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.opensource.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., status check, 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. TrademarksThis project may contain trademarks or logos for projects, products, or services. Authorized use of Microsoft trademarks or logos is subject to and must follow Microsoft's Trademark & Brand Guidelines. Use of Microsoft trademarks or logos in modified versions of this project must not cause confusion or imply Microsoft sponsorship. Any use of third-party trademarks or logos are subject to those third-party's policies. |