Tabular Editor 3.3.5

Tabular Editor 3.3.5 downloads:

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.

Important!

NOTE: Tabular Editor 3.3.0 (and newer) uses .NET 6. You may have to install the .NET 6.0 Runtime for Desktop before you can launch Tabular Editor 3.3.0 (or newer). Starting from 3.3.1, the Tabular Editor 3 installer will download and install these prerequisites, if they are missing.

Improvements in 3.3.5

  • New splash screen and icon, matching our new website brand.
  • Updated TOM to 19.48.0.
  • Tabular Editor 3 now has a set of configurable policies, which let IT organisations govern certain Tabular Editor 3 features.
  • Column widths can now be locked on the Messages, Macros and BPA views.
  • Improved the Macros view with a right-click menu and toolbar buttons to open/edit macros.
  • Added semantic analyzer and autocomplete support for the EVALUATEANDLOG and SAMPLEAXISWITHLOCALMINMAX DAX functions.
  • The "Revert" File menu option is now also available when a model was loaded from disk.
  • DAX debugger now supports more types of DAX queries, specifically it is now possible to debug cell values when the query uses ADDCOLUMNS, CALCULATETABLE, SAMPLE, SAMPLEAXISWITHLOCALMINMAX, SUBSTITUTEWITHINDEX and SUMMARIZE. This should ensure that most types of queries generated by PBI Desktop can be used with the TE3 debugger. Note that only cell values that originate from explicit measures can be debugged.
  • Added a "Step into selection" option in the DAX debugger to make navigation easier. Use the shortcut key (Ctrl+B) or right-click anywhere in the code and choose "Step into selection" to navigate.
  • Better visualisation of objects with errors/warnings in the TOM Explorer. Better icons in the Data Refresh tab.

Bugfixes in 3.3.5

  • More reliable detection of Azure AS Developer tier (D1), which would sometimes prevent Business Edition customers from accessing the AAS instance.
  • Allow role name changes in PBI Desktop restricted mode, see #624.
  • Fix SortByColumn not settable, see #625.
  • Fixed an issue that would prevent Tabular Editor to connect to ODBC data sources, when connection string properties were specified as "Extended Properties" in the connection string.
  • Use TOP row limit clause for Snowflake ODBC by default.
  • Fix issue with wait spinner overlapping "SelectItem" dialog when executed as script/macro. See #622.
  • Fixed an issue with how the debugger handles (blank) and binary values in filters.
  • Automatic fallback to Protocol Format=xml if the connection fails due to invalid Binary XML. See #637.
  • Fix "Batch rename" not available in Power BI Desktop models.
  • Add M parser support for special characters, see #638.
  • Treat 'version' as a DAX reserved word (i.e. always quote and show an error if used unquoted or as a variable name).

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