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.

Visual studio code auto format css