Once the SDK has installed, you can check by opening VS Code and running the following command at a terminal: dotnet -info I use version 3.1.301, so any version that matches this or later is fine.ĭownload and install the SDK executable using default settings. Net Core runtime (which gets installed by the SDK) – it needs to be the SDK. On a browser navigate to the download page for the. Use default settings when prompted during the install. Open a browser and navigate to then download and run the installer for the current version for Windows. The following step by step exercise will be to download and configure VS Code to the point where it can connect to a Power BI Desktop file and add a new measure. You can also connect to models hosted in Azure Analysis Services as well as models hosted in Power BI Premium. The following exercise uses VS Code to connect and manage a Power BI Desktop model. I just thought it would be fun to show how quick and easy it is to get up and running in VS Code in very few steps. There is nothing you can do in VS Code that you can’t also do in another tool using TOM.

Visual Studio Code is a reasonably new development environment which is lightweight and quick to install and get up and running. Net Core version that works nicely with Visual Studio Code. Now the TOM client libraries also have a. Net framework, which meant they were complicated to use with Visual Studio Code. Previously, TOM client libraries only supported the. We could create scripts to run in Visual Studio or PowerShell for quite a while, but a recent update to the TOM client libraries now make it very easy to use Visual Studio Code for such requirements. Many of these tasks can be completed by creating TOM based scripts to run in your tool of choice. Still, sometimes you have a task that isn’t so easy to complete one of the existing tools. We already have fantastic tools such as SSDT, Tabular Editor and ALM toolkit that use TOM to connect and update existing data models. Power BI data models are hosted in an instance of an Analysis Services, either running locally in Power BI Desktop or published to the web service.Īnalysis Services provides the ability for external tools to connect and manage models using the Tabular Object Model (TOM). The technique not only allows you to browse the underlying model easily but also enhance and change such as adding/changing measures. For this blog, I want to share a technique that allows you to use tools such as Visual Studio Code to connect and make changes to Power BI models.

Power bi desktop download for mac