TMDL scripts, notebooks, and Tabular Editor: how does it all fit together?

However, we’ve also had a lot of questions from the Power BI community about these new tools and features, such as how they fit in with Tabular Editor: 

• What’s the difference between TMDL scripts, Tabular Editor C# scripts and DAX scripts? 

• When would I use the DAX query view in Power BI Desktop, compared to DAX studio, or the DAX query view that’s in Tabular Editor 3? Are they different or the same thing? 

• If I have Fabric, can I use semantic link to develop a model instead of third-party tools? 

• Can’t I use Copilot or other AI tools to develop my semantic model? 

• Do I still need third-party tools? 

In the next few articles, we will not only introduce some of these new tools and features but also answer some of these questions. We’ll also explain how Tabular Editor fits well into this evolving tool ecosystem. 

As our CTO and creator of Tabular Editor Daniel Otykier wrote in his LinkedIn blog post published last year, you can develop and manage a semantic model perfectly fine by using only Power BI Desktop. To make a useful semantic model and to work productively, you don’t need to rely on third-party tools. Power BI has a rich ecosystem of third-party tools because building semantic models and reports is a complex process that involves many parts and pieces. You encounter a lot of scenarios or problems during development that simply aren’t well addressed by the out-of-the-box Power BI features; that’s why third-party tools exist. 

To say it another way: third-party tools are specialized. They help you solve specific problems or address specific scenarios. They give you an advantage when you encounter those problems or scenarios. For instance, Tabular Editor is a tool that’s intended to support professionals who focus on semantic model development, so that they have every advantage to be as effective and productive as possible. 

Here are some simple examples: 

• When developing a model, you need a multi-tool; a Swiss army knife loaded with different specialized instruments that can help you in a pinch. For example, Tabular Editor 3 has a swathe of DAX code assistance features that help you write, improve, and optimize DAX code: 

• • Smart suggestions with calltips, syntax, and other explainers to help you understand functions and their arguments. 

• • Shortcuts to quickly refactor code by renaming or finding and replacing substrings, references, or entire code patterns. 

• • Shortcuts to more quickly check code (like peek definition), navigate between references (like go to definition), and view documentation or examples. 

• • Code actions to suggest code improvements and warnings to alert you to issues before they become a problem in implementation. 

• Customizing your development environment is key. Popping out and rearranging windows, setting up and saving custom layouts, toolbars, and shortcuts all can lead to massive productivity gains for an experienced developer who can waste less time on menial tasks and focus on just getting work done. 

• When we work, we don’t want to wait for “working on it…” to stop spinning. Tabular Editor is lightning-fast, even with the largest and most complicated models, because you are only ever working with metadata. Even big changes like deleting tables are instant, and you don’t have to wait while refreshing one or more model tables to continue your work.    

• In any developer tool, you will make mistakes and want to undo your changes. In Tabular Editor, Ctrl + Z will undo any change, even deleting a model data table.  

These are just a few examples. If you want more details, we have a new course Tabular Editor for Beginners which we are releasing on Tabular Editor Learn. This course walks you through the basics of semantic models and Tabular Editor, including the features and how they help you. 

So, do you need Tabular Editor? No, much like how you don’t need a gym membership, coaching, or supplements to get in shape. However, if you’re serious about something, then you want tools and resources that give you the upper hand and increase your chances of success. That’s what Tabular Editor is all about; giving developers the instruments and advantages to help you succeed with semantic models. 

We don’t think that anyone should be forced to use third-party tools just because Power BI has features and properties that its user interface doesn’t reveal or support. That just locks out user segments from getting more value from their models. Thankfully, now, that’s no longer the case. 

However, there are many features which as of April 2025 don’t have a user interface to view or manage them: 

• Translations (or cultures). These are used to translate your model to other languages for end-users in their client tools like Power BI Desktop or Excel, based on their local settings. 

• Perspectives. These are used to create “subsets” of your model to make it easier to use in certain experiences, like personalize visuals, composite models, and even thin reports. 

• Object-level Security (or OLS; sometimes called “Column-Level Security”). This lets you restrict permissions to read certain columns; users will instead see errors if querying them. 

• Properties like IsAvailableInMdx and SourceColumn (for columns), IsPrivate (for tables), and others. These properties have certain use-cases where you might change them in certain scenarios. 

• Annotations or extended properties, which can be used to hold metadata relevant for client tools (like Field parameters) or store information relevant for developers and technical teams (such as VertiPaq statistics, usage information, search tags, and more). 

Until recently, the only way to use these features was to go through a complex process with first-party tools like SQL Server Management Studio (SSMS) or manually modify the model metadata in a text editor. That was incredibly inconvenient; so, most people used Tabular Editor 2 or 3. However, now, you can change these properties in local models by using the TMDL view in Power BI or in published models by using semantic link in notebooks. 

Essentially, the TMDL view and semantic link provide a more convenient and accessible route for users to leverage these features by using first-party tools only. That is fantastic; thanks to the effort of key members of Microsoft and the Power BI community, the limitations and restrictions are lifted. This is particularly valuable for users who cannot use third-party tools due to restrictive policies in their organizations, or users who simply prefer to limit their work to fewer or first-party tools. 

The purpose and main benefits of Tabular Editor are not to give users access to these features; this was simply a coincidence of providing full visibility on the Tabular Object Model (TOM), for the following reasons: 

• The TOM Explorer and properties windows of Tabular Editor provide an easy way to browse your “data pane” while also seeing every property for whichever object you select and its current values. You can also adjust and move these windows wherever you want. 

• Each property has a human-readable name, a simple description of what it does, and the expected values. 

• You can change any property in bulk, either with the user interface by shift-selecting multiple objects or programmatically by using C# scripts (which also be context-sensitive to whatever you are selecting in the TOM explorer). 

• Tabular Editor 3 has certain UI features designed to make some of these things easier, like a perspective and translation metadata management windows. 

In the next article, we’ll explain how all of this helps you to be more productive. In short, these new tools and third-party tools like Tabular Editor both help you to scale your tasks both within a single model and across multiple models, in different ways. What’s important is that you know when to use what and approach your model with a “toolbox mentality” to leverage everything at your disposal.