VS Code Extensions For Power BI Development and Administration
VS Code extension for Power BI Development and Administration
VS Code is a simple, powerful and highly customizable IDE. Features include syntax highlighting, intellisense, git version control, integrated terminal, and more. The Extension Marketplace offers additional languages and editor features. You can make your environment your own, by applying themes and setting up editor shortcuts and preferences.
Because of this, VS Code is the IDE most used by developers; as per the Stack Overflow 2023 Developer Survey.
Extensions¶
Here are subset of extensions I use for Power BI development, administration and automation.
Languages¶
| Language | VS Code Extension ID | Syntax Highlighting | Intellisense |
|---|---|---|---|
| TMDL | analysis-services.TMDL | ✔️ | ❌ |
| DAX | jianfajun.dax-language | ✔️ | ❌ |
| M | PowerQuery.vscode-powerquery | ✔️ | ✔️ |
| C# | ms-dotnettools.csharp | ✔️ | ✔️ |
| Powershell | ms-vscode.powershell | ✔️ | ✔️ |
| Python | ms-python.python | ✔️ | ✔️ |
| YAML | redhat.vscode-yaml | ✔️ | ❌ |
TMDL, DAX and M are used to review and update tabular models that have been decompiled to files (.pbip, pbitools, tabular editor). Powershell and C# for scripting using the analysis services libraries and cmdlets. Python and Powershell for scripting using the Power BI and Fabric REST APIs. YAML is used for developing GitHub/ADO pipelines.
Version Control¶
| Extension | VS Code Extension ID |
|---|---|
| Gitlens | eamodio.gitlens |
| Git Graph | mhutchie.git-graph |
These extensions extend VS Code's inbuilt git version control functionality. The features I use most are Inline blame annotation on rows, and On hover pop-up to show the details of commit.
GitLens: In-line Blame
GitLens: On Hover Blame Details
Commit graph and GitGraph. Commit graph, gives you a graph of commits, branches and merges over time, although I prefer Git Graph for this as it is simpler and more compact.
GitLens: Commit Graph
Git Graph: Git Graph