Tabular Editor 3.6.0

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

Prerequisites

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.

New in 3.6.0

Check out our release blog to get an overview of the most important updates in this release.

  • Tabular Editor 3 now has native support for Databricks. This means you can now connect to a Databricks SQL endpoint when importing tables using the Table Import Wizard. For more information, see our release blog post.
  • We added support for the new DAX functions RANK and ROWNUMBER introduced in the April 2023 update of Power BI Desktop. In addition, our code complete now shows all available keywords for the <Blanks> and <Order> arguments of the window and ORDERBY functions.

Minor improvements in 3.6.0

  • We no longer perform a (potentiallys slow) conflict check before saving changes to the workspace database. The assumption is that each developer uses their own personal workspace database, so conflicts should not occur.
  • C# scripting: The IAnnotationObject interface has been extended with a ClearAnnotations() method.
  • When adding a dynamic format string expression to a measure, we now clear the static format string property (as it is not possible for measures to have both static and dynamic format strings assigned).
  • Updated TOM to 19.61.1.4.
  • Default Compatibility Level for new Power BI models created with Tabular Editor, is now 1601. Moreover, the "create new model" dialog now lets you specify any compatibility level.

Bugfixes in 3.6.0

  • Oracle download instructions updated to instruct users to use the ODAC (not ODP.NET) drivers.
  • Removed restrictions on special characters in database names, when opening or creating a new database.
  • Fixed an issue that caused the database name property within the .bim / database.json file, to be updated with the name of the workspace database.
  • DAX debugger stability improvements.
  • .tmuo files are no longer saved, when the "Create user options (.tmuo) file" option is unchecked.
  • Fixed an issue where code complete would sometimes "absorb" closing brackets.
  • Semantic Analyzer no longer reports an error when using SELECTEDMEASURE (and related functions) in the context of measure expressions and format string expressions.
  • Fixed an issue where the M query generated for new tables imported from an existing implicit (SQL) data source, would not work correctly when attempting to refresh the table.

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