Tabular Editor 3.1.5

If you haven't used Tabular Editor 3 before, you are eligible to a 30 day trial, which can be requested after installation. You can also purchase a license.

Improvements in 3.1.5

  • You can now impersonate users or roles on DAX queries, Pivot Grids and Table Previews. This is useful for testing RLS and OLS settings. More information.
  • DAX scripts now support calculation groups and calculation items. This allows you to view all calculation group logic (including format string expressions) in a single document. Example.
  • When right-clicking on a measure reference in a DAX query or DAX script, there is now an option to add the definition of that measure including all dependencies.
  • You can now pan diagrams by dragging an empty area (see #275).

Bugfixes in 3.1.5

  • Fixed issue with the built-in schema updater when a null value is encountered in an M expression (see #282).
  • Semantic analyzer no longer reports an error when using the RELATED function in an argument to SELECTCOLUMNS(when no name argument is specified).
  • Macros can now be edited/renamed without disappearing from toolbar customizations (see #266).
  • All custom toolbars can now be renamed/deleted after restarting the application (see #260).
  • Fixed selection/context menu when selecting a folder of folders (see #248).
  • Prevented crash when simultaneously selecting tables/table objects.
  • Fixed various issues/crashes when importing tables (ODBC NullReferenceException, and more).

Coming from Tabular Editor 2.x?

Watch this video to get an idea of the new features in Tabular Editor 3.

Tabular Editor 3 major features overview:

  • Fully customizable IDE, with multi-monitor, Hi-DPI support and themes
  • New powerful DAX code editor with auto-complete, syntax checking, code folding and much, much more
  • *Workspace mode, allowing you to save your changes to disk and synchronise model metadata to Analysis Services simultaneously
  • *Preview table data with infinite scrolling, create PivotGrids or write DAX queries to browse the model or test calculation logic
  • *Schedule data refreshes
  • Update Table Schemas on both Provider and Structured Data Sources (yes, even for M queries!)
  • Create data model diagrams
  • Create DAX scripts that allow you to edit multiple measures or other calculated objects in a single document
  • Record C# scripts and save as macros (formerly known as "Custom Actions")
  • VertiPaq Analyzer integration

*=Only while connected to an instance of Analysis Services or Power BI