Announcing Tabular Editor Lite for VS Code

Key Takeaways

• Introducing a new cross-platform VS Code extension for semantic model editing: Tabular Editor Lite is a free VS Code extension for working with semantic models on Windows, macOS and Linux.
• A lightweight editor for simple development and collaborating with agents: The extension contains the basic features of Tabular Editor 2 and 3. It also has other features that help you work with third-party coding agents, like watch mode, edit history, comments, and context-awareness via the model-context protocol.
• An experiment from Tabular Editor Forge: This extension is the first released experiment from Tabular Editor Forge. These are small research projects we have conducted and tested internally and decided to release if it brings value to our community or customers.

This summary is produced by the author, and not by AI.

Here's a preview of Tabular Editor Lite, from installing the extension to editing a semantic model alongside a coding agent:

Tabular Editor as a VS Code extension

VS Code is a familiar place for many people working in Power BI. Whether you're writing code, working with agents, or just using it for source control management, VS Code has grown more common and popular over time. In running those workflows, we’ve found that we were missing Tabular Editor's capabilities, so earlier this year, we built an extension that brings some of them into VS Code: Tabular Editor Lite:

VS Code runs on all operating systems, and so does our extension. In addition to many of the features you already know from Tabular Editor 2 and 3, it includes many features that help you collaborate and work with agents.

Features of Tabular Editor Lite

Here’s a video that walks through the features of Tabular Editor Lite:

In this article, we go through some more details, introducing the extension and explain how you can get started using it. We'll continue improving it with your feedback; please let us know what you think.

Here is how Tabular Editor Lite compares to the other Tabular Editor tools:

The editor experience

You can connect to your model wherever it lives: on disk (TMDL folder, model.bim file or .pbip project), live in Power BI Desktop (Windows only) any XMLA endpoint (SSAS, AAS, or Power BI / Fabric. Once connected, you'll see the familiar tree structure in the Model Explorer;. Just like in Tabular Editor, you can select objects and the Properties Pane will show the detailed properties of those objects and let you edit them, multiple objects at a time.

It's not just editing though; the full create-read-update-delete is supported by TE Lite, and you can even copy/cut/paste objects across sessions of TE2, TE3 and the extension. Deleting comes with impact analysis of dependent objects that would be deleted along (e.g. relationships on a column).

For objects with expressions such as DAX measures and M partitions, a new tab will open with the editable expression. Coding support is there in the form of IntelliSense, document formatting, per-function links to documentation (dax.guide for DAX and PQM.guide for M). SQL and TMDL editors are also bundled in, where you can leverage the default features of VS Code or other supporting extensions:

This is the core loop of model development, in a new graphical user interface, with search and per-object unsaved change markers so it's easier to keep track of what changed since the last save. You can filter the Model Explorer to only show changed objects or those that have comments.

In the Diagram View, you can see and edit the relationships between the tables in your model, laid out on a canvas. The table positions can be re-arranged by dragging or auto-arranged with a button. Many-to-many relationships deserve your attention, so these are highlighted by default, and we also show the data types of related columns. You can use colors to mark tables, and those same color markings will be applied in the Model Explorer. The layouts can be saved as.te3diag files, the same format TE3 uses. Note, however that TE3 doesn’t support the same interface or coloring of tables:

Best Practice Analyzer (BPA) is here too, with either on demand or automatic runs on every edit. In the Model Explorer, objects with violations are marked as such. The BPA report lists all violating objects by rule and lets you load rule sets from file or URL with the option to edit the JSON directly. Existing TE2 and TE3 rule collections work as-is and model-scoped rules are supported.

The BPA comes with a set of basic rules, but you can also add your own like you do in TE2 or TE3:

Agent sidekicks

Maybe you've been using AI coding agents such as Claude Code, Codex and GitHub Copilot. The speed with which they can move makes them hard to follow or understand, and that's exactly what you want to avoid when building semantic models; you need to understand the model's current state, its previous state, and desired future state. If you don't understand the model, you can't trust it, and neither can anyone consuming data from it.

Tabular Editor Lite gives you transparency in what is happening through different means:

• Watch Mode. External changes made to models are visible without reconnecting or reloading. If your changes would collide with those external changes, Watch Mode will warn and ask you how to handle the conflict. Alternatively, the agent can make these changes directly to the in-memory session in Tabular Editor Lite, so you can see and review the changes in the editor UI.
• Edit History. Every change leaves a record in the Edit History, which exposes the history you’d typically only get with undo/redo. You can roll back to any point, and forward again.
• Comments. You, your colleagues and the agent can leave comments anchored to model objects. These comments are stored as threads in annotations of the model, so they travel along with it. The agent treats your threads as instructions; it acts on them and answers on the thread when it's done. Only you can resolve or delete threads.
• Agent context awareness. An MCP server gives your agent context so it can see what you have selected, down to the highlighted part of a DAX or M expression, and reveal things for you. It can also reload the editor, save changes (connect, disconnect and save ask you first) and rearrange the diagram, and it sets itself up for the agents it detects in your workspace.

These features work together: you leave comments as prioritized instructions so the agent can edit through TE Lite or the TE CLI. If you edit the model externally, then watch mode auto-reloads the editor, and the agent answers back on the comment thread.

Further Reading

• How to get value from the TE CLI (Tabular Editor Blog). Our hands-on blog to understand the te-cli, which you can use for programmatic model changes, agentic development, or CI/CD.
• GitHub Discussion (GitHub). Let us know here if you have any issues, feedback, or requests.
• The Tabular Editor Forge (Tabular Editor). Our research arm, where we share experimental software like Tabular Editor Lite as free downloads.

Conclusion

Tabular Editor Lite brings the core semantic model development loop to VS Code, with native agent support, for free. You can try it out by installing it from the marketplace and connecting to a model (or just use the built-in sample model). This is the v1 release we'll continue to improve with your feedback.