Getting to know Tabular Editor 3's User Interface
This article describes the user interface of Tabular Editor 3.
Basic user interface elements
The first time you launch Tabular Editor 3 and load a data model, you will be presented with an interface as shown on the screenshot below.
- Title bar: This shows the name or the currently loaded file and Analysis Services database or Power BI dataset if connected.
- Menu bar: The menu bar provides access to all of the various features of Tabular Editor 3. See Menus for a detailed walkthrough of all menu items.
- Toolbars: The toolbars provide quick access to the most commonly used features. All features accessible through the toolbar can also be accessed through the menus. You may customize the toolbars and their buttons under Tools > Customize...
- TOM Explorer view: A hierarchical view of your data model, with all objects available . of the metadata from the Tabular Object Model (TOM) metadata that represents your data model. The toggle buttons at the top allow you to filter which objects are displayed. The search box allows you to filter objects by names.
- Expression Editor: The expression editor provides a quick way to edit any DAX, SQL or M expressions of the currently selected object in the TOM Explorer. If you close the expression editor, you can bring it back up by double-clicking on an object in the TOM Explorer. The dropdown at the top allows you to switch between different expression properties, in case the currently selected object has more than one such property (for example, KPIs have Target Expressions, Status Expressions and Trend Expressions, which are 3 different DAX expressions belonging to the same KPI object).
- Properties view: A detailed view of all TOM properties available on the currently selected object(s) in the TOM Explorer. Most properties can be edited through the grid, even when multiple objects are selected. Some properties (such as "Format String", "Connection String", "Role Members") have popup dialogs or collection editors that can be brought up by clicking on the ellipsis button within the property value cell.
- Messages view: Tabular Editor 3 continuously analyzes the DAX expressions on your model for semantic errors. Any such errors are outputted here. In addition, messages shown in this view, can originate from C# scripts or from error messages reported by Analysis Services.
- Status bar: The status bar provides various contextual information about the current selection, Best Practice Analyzer findings, etc.
There are a number of additional views available, serving various purposes. More information in the View menu section.
Customizing the user interface
All UI elements may be resized and/or rearranged to fit your needs. You can even drag individual views out of the main view, thus splitting up an instance of Tabular Editor 3 across multiple monitors. Tabular Editor 3 will save the customization when the application is closed, and reload it automatically upon next launch.
Choosing a different layout
To reset the application to the default layout, choose the Window > Default layout option. Users of Tabular Editor 2.x may prefer the Window > Classic layout option which places the TOM Explorer on the left side of the screen, and the Properties view below the Expression Editor.
Use the **Window > Capture current layout..." option to save a customized layout such that it will become available as a new layout option within the Window menu, allowing you to quickly switch back and forth between different layouts. Use the Window > Manage layouts... option to bring up a list of all available layouts, allowing you to rename, save, delete layouts, etc. When saving a layout to disk, the result is an .xml file which you can share with other users of Tabular Editor 3.
Changing themes and palettes
The visual appearance of Tabular Editor 3 can be changed by choosing a different theme and/or palette. Tabular Editor 3 ships with five different themes (sometimes called "skins"), available through the Window > Themes menu:
- Basic and Bezier (vector based, works well on high-DPI displays)
- Blue, Dark and Light (raster based, not recommended for high-DIP Displays)
For the vector based themes (Basic and Bezier), use the Window > Palette menu item to change the colors used by the theme.
The following section describes the menus in Tabular Editor 3 in more details.
We use the term Active document in the following section, to mean that the cursor is placed within a document such as the Expression Editor or the "DAX Script 1" tab in the screenshot below. Some keyboard shortcuts and menu items behave differently depending on whether there is an active document or not, and what type of document is active.
The File menu primarily contains menu items for dealing with loading and saving model metadata and supporting files and documents.
New: Opens a submenu that allows you to create a new blank data model (Ctrl+N), or create various supporting files such as a new DAX Query or DAX Script (text files) or a data model diagram (JSON file). Supporting files (with the exception of C# scripts), can be created only when a model is already loaded in Tabular Editor.
The New > Model... option is not available in Tabular Editor 3 Desktop Edition, as this edition may only be used as an External Tool for Poewr BI Desktop. More information.
Open: Opens a submenu with options for loading a data model from various sources, as well as on option for loading any other type of file. The submenu items are:
Model from file... Open model metadata from a file such as a .bim or .pbit file.
Model from DB... Specify Analysis Services or Power BI XMLA connection details, or connect to a local instance of Analysis Services (such as Visual Studio's Integrated Workspace server or Power BI Desktop), in order to load model metadata from a tabular model that has already been deployed.
Model from folder... Open model metadata from a folder structure which was previously saved using any version of Tabular Editor.
File... displays a dialog that lets you open any type of file supported by Tabular Editor 3, based on the file name extension. See Supported file types for more information.
In Tabular Editor 3 Desktop Edition the Open > Model from file... and Open > Model from folder... options are not available and the Open > File... dialog only allows opening supporting files, not files containing metadata.
- Revert: This option lets you reload the model metadata from the source, discarding any changes that are made in Tabular Editor, which have not yet been saved. This option is useful when Tabular Editor 3 is used as an External Tool for Power BI Desktop, and a change is made in Power BI Desktop while Tabular Editor 3 is connected. By choosing Revert, Tabular Editor 3 can reload the model metadata from Power BI Desktop without having to reconnect.
- Close: This closes the active document (for example a DAX Query, a C# script or a data model diagram). If the document has unsaved changes, Tabular Editor will prompt you to save the changes before closing.
- Close model: This unloads the currently loaded model metadata from Tabular Editor. If you made changes to the metadata, Tabular Editor will prompt you to save the changes before closing.
- Save: This saves the active document back to the source file. If no document is active, this saves the model metadata back to the source, which could be a Model.bim file, a Database.json (folder structure) or a connected instance of Analysis Services (including Power BI Desktop) or the Power BI XMLA endpoint.
- Save as... This allows you to save the active document as a new file. If no document is active, this allows you to save the model metadata as a new file, using the .bim (JSON-based) file.
- Save to folder... This allows you to save the model metadata as a folder structure.
- Save all: Saves all unsaved documents and model metadata at once.
- Recent files: Displays a list of recently used supporting files allowing you to quickly reopen them.
- Recent tabular models: Displays a list of recently used model metadata files or folders, allowing you to quickly reload model metadata from one of these.
In Tabular Editor 3 Desktop Edition the Save to folder and Recent tabular models options are disabled. In addition, the Save as option is only enabled for supporting files.
- Exit: Shuts down the Tabular Editor 3 application. You are prompted to save any unsaved files or model metadata before the application is shut down.
The Edit menu contains standard Windows application menu items for editing a document or making changes to the currently loaded model metadata.
- Undo: This option undoes the last change made to the model metadata. When there is no active document, the familiar CTRL+Z shortcut maps to this option.
- Redo: This option undoes the last undo against the model metadata. When there is no active document, the familiar CTRL+Y shortcut maps to this option.
- Undo typing: Undoes the last text change in the currently active document. When there is no active document, this option is not available.
- Redo typing: Undoes the last undo within the currently active document. When there is no active document, this option is not available.
- Find: Displays the "Find and replace" dialog with the "Find" tab selected. More information.
- Replace: Displays the "Find and replace" dialog with the "Replace" tab selected. More information.
- Cut / Copy / Paste: These are the familiar Windows editing operations. If there is an active document, then these apply to the text selection within that document. Otherwise, these options may be used to manipulate objects in the TOM Explorer. For example, you can duplicate multiple measures by holding down the SHIFT or CTRL key while selecting the measures in the TOM Explorer, then hitting CTRL+C followed by CTRL+V.
- Delete: Deletes the selected text in the active document, or the currently selected object(s) in the TOM Explorer if there is no active document.
Tabular Editor generally only prompts for object deletion when multiple objects are selected, or when there are dependencies to the object(s) being deleted. Object deletion can be undone by using the Undo option (CTRL+Z).
- Select all: Selects all text in the currently active document, or all objects belonging to the same parent within the TOM Explorer.
- Code assist: This option is available when editing DAX code. It provides a shortcut to various code assist features relevant for editing DAX code. See DAX editor for more information.
The View menu lets you navigate between the different views of the Tabular Editor 3 UI. If a view has been hidden, click on the view title in this menu will unhide the view and bring it into focus. Note that documents are not shown in the View menu. To navigate between documents, use the Window menu.
- TOM Explorer: The TOM Explorer presents a hierarchical view of the entire Tabular Object Model (TOM) of the currently loaded model metadata. See TOM Explorer view for more information.
- Best Practice Analyzer: The Best Practice Analyzer helps improve the quality of your model by letting you specify rules for best practice validation. See Best Practice Analyzer view for more information.
- Messages: The Messages view displays errors, warnings and informational messages from various sources, such as the Tabular Editor 3 Semantic Analyzer. See Messages view for more information.
- Data Refresh: The Data Refresh view allows you to track data refresh operations that are running in the background. See Data Refresh view for more information.
- Macros: The Macros view allows you to manage any macros you have created. Macros can be created from C# Scripts. See Creating macros for more information.
- VertiPaq Analyzer: The VertiPaq Analyzer view allows you to collect, import and export detailed statistics about the data in your model, to help improve and debug DAX performance. VertiPaq Analyzer is created and maintained by Marco Russo of SQLBI under MIT license. More information on the GitHub project page.
- Expression Editor: This is the "quick editor" that lets you edit DAX, M or SQL expressions on whichever object is currently selected in the TOM Explorer. See DAX Editor for more information.
The Model menu displays actions that can be performed at the level of the Model object (the root object of the TOM Explorer).
- Deploy...: Launches the Tabular Editor Deployment wizard. For more information, see Model deployment.
The Deploy option is not available in Tabular Editor 3 Desktop Edition. For more information see Compare editions.
- Import tables... Launches the Tabular Editor 3 Import Table Wizard. For more information, see Importing Tables.
- Update table schema... Detects schema changes in the data source(s) for the currently selected table(s) or partition(s) compared to the currently imported columns. See Importing Tables for more information.
- Script DAX: Generates a DAX script for the currently selected object(s) (or all DAX objects in the model, if nothing is selected). See DAX Scripts for more information.
- Refresh model: When Tabular Editor is connected to an instance of Analysis Services, this submenu contains options for starting a background refresh operation at the model level. The submenu has the options below. For more information, see Refresh command (TMSL).
- Automatic (model): Analysis Services determines which objects to refresh (only objects that are not in the "Ready" state).
- Full refresh (model): Analysis Services performs a full refresh of the model.
- Calculate (model): Analysis Services performs a re-calculation of all calculated tables, calculated columns, calculation groups and relationships. No data is read from the data sources.
- Create [object type]: The remaining shortcuts in the Model menu lets you create new types of model child objects (tables, data sources, perspectives, etc.).
The Tools menu contains options for controlling Tabular Editor 3 preferences and customizations.
- Customize... Launches the Tabular Editor 3 User Interface Layout customization dialog, which lets you create new toolbars, rearrange and edit menus and toolbar buttons, etc.
- Preferences... Launches the Tabular Editor 3 Preferences dialog, which is a central hub for managing all other aspects of Tabular Editor and its features, such as update checks, proxy settings, query row limits, request timeouts, etc. See Controlling preferences for more information.
The Window menu provides shortcuts for managing and navigating between the various views and documents (collectively known as windows) of the application. It also has menu items for controlling the theming and color palettes as described above.
New... this submenu provides a shortcut for creating new supporting files. The options here are identical to those under File > New.
Float undocks the current view or document into a floating window.
Pin tab pins a tab. When a tab is pinned, it is shown at the left-most side of the document tabs, and when right-clicking on the tabs, shortcuts are available for closing only unpinned tabs.
New Horizontal/Vertical Tab Group: This option lets you divide the main document area into multiple sections (aka. "tab groups), in order to have multiple documents displayed simultaneously side-by-side or top-by-bottom.
Close All Documents: Closes all document tabs. You are prompted to save unsaved changes, if any.
Reset Window Layout: Resets all customization applied to the main document area.
1..N [document]: The first 10 open documents are listed here, allowing you to navigate between them. You can also use the CTLR+Tab shortcut to quickly switch between open documents and views, such as shown in the screenshot below:
Windows...: Opens a dialog listing ALL open documents, allowing you to switch between them or close them individually.
Capture current layout / Manage layouts... / Default layout / Classic layout: These menu items were discussed earlier in this article.
Theme / Default palette: These menu items were discussed earlier in this article.
The Help menu provides shortcuts for online resources and more.
- Getting Started: This menu item links to this article.
- Tabular Editor 3 Docs: This menu item links to docs.tabulareditor.com.
- Community Support: This menu item links to our public community support site.
- Dedicated Support: This menu item lets you send an e-mail directly to our dedicated support hotline.
Dedicated support is reserved for Tabular Editor 3 Enterprise Edition customers. All other customers should reach out on the public community support site for any technical issues, questions or other product-specific questions.
- About Tabular Editor: Launches a dialog that shows detailed information about the version of Tabular Editor being used as well installation and licensing details. The dialog also lets you change your license key.
Dynamic menus (context dependent)
In addition to the menus mentioned above, other menus may appear at certain times, depending on which UI element currently has focus and which object is currently selected in the TOM Explorer. For example, if you select a Table-object, a Table menu will appear, holding the same context-specific shortcut items as when you right-click on that object in the TOM Explorer.
If you switch the input focus between different types of documents (i.e. DAX queries, Pivot Grids, diagrams, etc.), you should also see a menu representing the type of document currently in focus. That menu will hold items relevant for the current document. For example, when a diagram currently has focus, there will be a Diagram menu which has an item for adding tables to the diagram, among others.
You can change the behavior of these dynamic menus under Tools > Preferences > User interface.