Tabular Editor 3.2.3

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.2.3

  • Updated TOM to 19.36.0
  • Use compatibility level 1569 for new PBI models
  • Allow serialization of CalculationGroups and CalculationItems using ExportProperties. See #976
  • Allow specifying MemberID on .AddExternalMember and .AddWindowsMember, see #484 and #483
  • Allow specifying raw XMLA in calls to ExecuteCommand, as discussed in #495
  • Allow copying Pivot Grid MDX query to clipboard by right-clicking anywhere in the Pivot Grid, see #494.
  • Improved BPA view (show severity, category) as well as tooltips. See #489.
  • Change default on the VertiPaq Analyzer "Read statistics from data" setting to "false" to align with DAX Studio / Bravo.
  • Added new option to make Auto Complete popups less aggressive (only popup after entering a letter character), see#459. Locate this setting under Tools > Preferences > DAX Editor > Code Assist.

Bugfixes in 3.2.3

  • Fix issue with table permissions not being properly deserialized. See #446.
  • Fix crash during startup with certain layouts, see issue #455.
  • Fixed an issue that could cause the application to crash when measures or other objects have curly braces in their names.
  • Remove asterisk'ed properties (keys, passwords) when "Include sensitive" is set to false. See #479.
  • Fix save-to-folder serialization when using invalid file/folder names as object names, or when an object name contains a trailing space. Similar to #952 and #978.
  • Show all refresh options if at least 1 non-calculated table is selected, see issue #487
  • Fix semantic analyzer column lineage issue with UNION, see #482.
  • Fix issue with shortcuts not working on floating windows, see #480.
  • Do not show "EnableRefreshPolicy" property for calc tables, calc groups, or DirectQuery tables, see #470.
  • Fix Import Table Wizard issue when creating new structured data sources in some scenarios (for example, Oracle data sources).
  • Fix crash when trying to add Structured ODBC data source through Import wizard.
  • Fix diagram select issue when clicking on a column in another table.
  • Fix issue with TOM explorer not updating to show the proper object type of a partition when its mode is changed
  • Fix format of measures displayed in Pivot Grid, see #492
  • Auto-complete should not insert parentheses if there's already an opening parenthesis by the cursor, see#459
  • Fixed autocomplete for CONVERT 2nd param (data type), see #474.
  • Starting a new rename operation should complete any existing ones, see#461.
  • Fix issue with multiple EVALUATE statements not respecting ORDER BY when executing selection only. Also fixed an issue where ORDER BY didn't work on tables with names that are also DAX functions. See #472

Coming from Tabular Editor 2.x?

Watch this video to get an idea of the new features in Tabular Editor 3. Also, make sure to check our onboarding guide.

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
  • *DAX debugger

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