Tabular Editor 3.1.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.

Bugfixes in 3.1.3

  • Fixed a memory leak that occurs when the application is idle. This issue has existed since v. 3.1.1.

Bugfixes in 3.1.2

  • Fixed an issue with Update Table Schema not working for SQL DW / Synapse SQL Pool data sources, see #231.
  • Fixed an issue where ignored rules were still considered by the Best Practice Analyzer, see #203.
  • Fixed an issue where models could not be saved to disk (file or folder) due to a JSON serialization error, see #232.
  • Fixed an issue that caused a crash when inspecting the property values of a Structured Data Source.

Improvements in 3.1.1

  • Shared Expressions (Power Query / M expressions) can now be serialized as individual files. You can control the serialization under Tools > Preferences > Save-to-folder or for an existing model under Model > Serialization options... (#218)
  • New options for controlling how perspective memberships are applied to new objects under Tools > Preferences > Modeling Operations (see issue #216).
  • PrivacySetting property can now be excluded from serialization, to prevent issues with Microsoft.AnalysisServices.Deployment. This is controlled under Model > Serialization options... (see issue #210).
  • You can now define enums, structs and classes directly within a C# script, making it easier to structure and reuse C# code.
  • VertiPaq Analyzer now has an option to collect statistics from data (Tools > Preferences > VertiPaq Analyzer), improving the quality of the statistics, for example when columns have IsAvailableInMDX = false. See issue #190.
  • When a new model is created, Tabular Editor 3 now prompts if the model should be saved as a file or folder, the first time it is saved. You can also set the default mode under Tools > Preferences > General > Default save format for new models. See issue #50.
  • Improved startup performance (some users have reported additional startup time gains by adding the -multicorejit switch to the TabularEditor3.exe shortcut).
  • Restructured the "Model" menu to make options such as "New calculation group" readily available.
  • Updated AMO/TOM client libraries to 19.26.1.7.
  • Model Role Members can now be iterated individually in the Best Practice Analyzer
  • "Workspace" within the "Window" menu has been renamed to "Layout" to avoid confusion with Workspace Mode.
  • Added Ctrl+Shift+D as a shortcut for "Deploy"
  • Support for new DAX functions (HASH, NAMEOF, COLUMNSTATISTICS, BITAND, BITLSHIFT, BITOR, BITRSHIFT, BITXOR) and support for optional column name parameter in SELECTCOLUMNS.

Bugfixes in 3.1.1

  • TOM Explorer should no longer freeze or crash when deleting objects (see issues #223, #209).
  • Fixed a color issue with dark themes in editors (#207) and icons (#215)
  • Tables are now sorted alphabetically in the "Create/Edit Relationship" dialog (see issue #214
  • Fixed an issue with C# scripts that prevented saving them as macros (see issue #208).
  • Fixed an issue with data source passwords/credentials not being properly applied to workspace database (see issue #205).
  • "Select all columns" checkbox should no longer cause a crash (see issue #204).
  • Tabular Editor now always looks in the installation directory when a script references external DLL's (using the #r precompiler directive), see issue #192.
  • Fixed a bug with linguistic schema that caused Q&A to stop working some cases
  • Filtering on a date column in Data Preview should no longer cause a crash
  • When selecting all perspectives in the TOM Explorer perspectives-dropdown, objects that do not included in any perspectives are no longer shown. Also fixed an issue with the dropdown box not updating perspective names.
  • Allow using certain DAX keywords as variables (WEEK, DAY, INTEGER, etc.) without showing an error.
  • Fix issue with serialization options not being stored the first time a model is saved.
  • Fixed an issue with the DAX parser which would cause a crash upon loading a model (see #229).

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