TabularEditor/TabularEditor3 3.3.2

Tabular Editor 3.3.2

on GitHub

• Download Tabular Editor 3.3.2 (64 bit) (recommended)
• Download Tabular Editor 3.3.2
• Portable versions: x64, x86

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 as well as the Microsoft Visual C++ Redistributable package 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.

Bugfixes in 3.3.2

• Fixed a bug in the installer, which caused some files not to be updated when performing an in-place upgrade, which in turn could cause application crashes and other issues, see #586.
• Added support for the ExpressionSource property on the NamedExpression class.

Improvements in 3.3.1

• New Installer which automatically downloads and installs missing .NET Runtime and VC++ prerequisites, if they are missing.
• Added support for the DAX NETWORKDAYS function.
• Updated TOM to 19.42.0.4

Bugfixes in 3.3.1

• Fixed an issue with C# tooltips not showing xmldoc comments, unless application launched from installation folder.
• Semantic Analyzer now correctly reports an error when using special MDX reserved keywords as unquoted table references.
• Fixed an issue where attempting to deploy a model loaded from a .pbit file would fial.
• Fixed an issue with compilation of C# scripts and macros. See #570, #573 and #580.
• Fixed an issue that prevented loading models containing calculation groups with one or more erroneous measures, see #571.
• Fixed an issue with the diagram not automatically refreshing after reloading a model, see #572.
• Fixed an issue that prevented the C# script engine from importing certain DLLs, see #574.
• Fixed an issue that prevented connecting to Power BI Desktop after making a choice in the "Local instances" dropdown, see #579.
• Fixed an issue where the TOM Explorer would select all objects (even when filtering the TOM Explorer), when pressing CTRL+A, see #582.
• Various stability improvements based on anonymous telemetry/error reports.

Improvements in 3.3.0

• Updated TOM to 19.39.2.2
• Tabular Editor 3 now uses Roslyn for C# script compilation. This means that your C# scripts can now use all the wonderful new language features of C# 10.0. Moreover, you can define classes and other types directly within your scripts. Last but not least, we finally have Roslyn-powered code completion and calltips for C# scripts (see screenshot).
  
• On a similar note, make sure to check out our new Scripting API docs site, where you'll find up-to-date documentation for all of the objects and members you can access through Tabular Editor 3's C# scripting feature.
• We also have a great improvement for the auto complete feature in our DAX editors, which will now show tooltips providing more information about the objects in the auto complete list. The tooltip will show the Description of measures, columns, etc. If no description is specified, we'll show the first 10 lines of DAX code on the object:
  
• When opening a model from Analysis Services or the Power BI XMLA endpoint, we now provide options to help you avoid making changes to the model by mistake, which is useful when you have multiple instances of Tabular Editor 3 open. The Mode dropdown (see screenshot below) lets you open a model in read-only or read/refresh-only mode. The Status bar color dropdown lets you set a color for Tabular Editor 3's status bar, so you can easily distinguish for example production, test, and dev models that are simultaneously open in different instances of Tabular Editor. See #558.
  
• We have finally added the "Duplicate object" context menu option (Ctrl+D) in the TOM Explorer, see #501.
• Added support for Snowflake OAuth and ExternalBrowser authentication, see #546.
• Property grid now has a search bar.
• Added more proxy configuration options under Tools > Preferences > Proxy Settings.
• Updated SQL Native Client library to the latest version. Connections to SQL Server now require encryption by default (unless connecting to localhost).
• Added a Refresh clear option at the model, table and partition levels, see #511.
• Added checkbox to open data models without workspace database, #523.

Bugfixes in 3.3.0

• Fixed an issue with how the semantic analyzer handles the NAMEOF DAX function, which could sometimes cause a crash, see #538.
• Property grids and collection editors now use the DevExpress com are now skinned and scaled correctly on hi-dpi monitors, see #548.
• Fixed a bug where the Refresh model submenu would sometimes disappear from the Model menu.
• "Update table schema..." will now correctly deal with columns where the name has only changed in casing.
• TE3 Business Edition now prevents adding multiple partitions/perspectives to AS models (which will prevent TE3 from loading the same model later due to edition restrictions).
• Fixed an issue where editor actions would sometimes be disabled, see #519.
• Fixed an issue with the Cancel and Cancel All buttons not being enabled after starting a refresh operation.
• Fixed an issue where refresh progress would not show when refreshing a Power BI model through the XMLA endpoint.
• Fix typo, see #553.
• Fix issue with calltips appearing despite unticking the "Show parameter info automatically" setting, see #545.
• Fix comment/uncomment bug, see #536.
• Fix issue with wrong return type on CUSTOMDATA(), see #527.
• In the data preview, when filtering a string column for "(Blanks)", we now include both BLANK and "" strings, see #524.
• Fix "Tabular Editor was not able to open the specified file" error when attempting to open a database.json file through the generic open file dialog, while "All files" is selected in the dropdown. See also #563.
• Fix bug with Save feature not respecting serialization settings checkbox choice.
• Fix color of link in status bar. See #521.
• Fix crash when attempting to clear orphaned traces in the preferences dialog.
• Fix false positive semantic error issue when comparing with variants, see #516.
• Fix issue with DAX generation when debugging a variable assignment containing IF/SWITCH function calls, see #513.
• Do not allow WEEK as interval parameter for DATEADD. See #508.
• Show calc item error indicator on the calc group table, see #506.
• Fix issue with c# script method ImportProperties not correctly resolving object paths.
• Added link to self-service portal when number of installations exceeded. Updated URLs/links to various places
• Better DAX code generation when debugging USERELATIONSHIP.
• Allow unchecking saving model metadata backup preference. Better error message when model metadata backup fails. Allow cancellation of model metadata backup.
• Fixed an issue with REMOVEFILTERS. See #562.

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