Table of Contents

Tabular Editor 3.26.0

Tabular Editor 3.26.0 downloads:

If you haven't used Tabular Editor 3 before, you are eligible to a 30 day trial, which can be activated after installation. You can also purchase a license.

New in 3.26.0

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

  • Our AI Assistant is now in public preview. Click the link to learn more.

Improvements in 3.26.0

  • Databricks support improvements
    • We now support the new Databricks ODBC Driver in addition to the legacy Simba Spark ODBC Driver.
    • Added OAuth (OIDC) authentication support for Databricks connections, enabling browser-based sign-in for both Azure and multi-cloud Databricks workspaces.
    • The Azure AD authentication option is now hidden for multi-cloud (non-Azure) Databricks connections, since it requires the Azure Databricks resource ID.
    • Added advanced connection options for Databricks: Query Tags, Implementation, Metric View BI Compatibility Mode, and Enable Automatic Proxy Discovery.
    • Semantic Bridge now supports v1.1 Metric Views metadata
  • DAX support improvements
    • Add support for table references in NAMEOF function.
    • Add support for TABLEOF function.
    • DATEADD now gives better error messages when its optional parameters are used without a calendar reference.
    • Add support for the new optional EndBehavior parameter of DATESINPERIOD function.
    • Add auto-complete support for MEASUREREF, COLUMNREF, TABLEREF and CALENDARREF as UDF parameter type hints.
  • C# script improvements
    • We now have a Run script with preview button, which will display a dialog showing all the changes made to the model by the script, after the script executes successfully. This way, you have a chance to review the changes and optionally revert the script.
    • Added complete singular and plural accessor support in C# scripts for all object types. You can now use Selected.Role to get a single role, Selected.KPIs to get all selected KPIs, and similar patterns for calculated table columns, folders, relationships, table permissions, and generic objects, making scripts more intuitive and easier to write. Learn more.
    • Improved the Semantic Bridge C# scripting interface to be more aligned with TOMWrapper for programmatic manipulation of Metric Views
  • Other improvements
    • Added a toolbar toggle button in the TOM Explorer to show or hide table groups, making it easier to control how tables are organized in the tree view without navigating through the preferences dialog.
    • Update NuGet packages including Microsoft.AnalysisServices to 19.113.2 and Scintilla.NET to 6.1.2.
    • When opening a model with a workspace database, Tabular Editor now detects changes to incremental refresh Source Expression or Polling Expression and prompts before overwriting workspace partitions. This prevents accidental loss of expression changes when collaborating via Git.
    • Added new Built in BPA rule to verify that UDFs uses seperators to ensure UDFs won't break if Microsoft creates a new DAX function.

Bugfixes in 3.26.0

  • Multiple Calendar Editor bugfixes and stability improvements
  • Macro tooltips are shown correctly in TOM Explorer, toolbar buttons and header menu items
  • Fixed a bug where BPA rule tooltips appeared on violating object rows in the Best Practice Analyzer, interfering with right-click context menus. Tooltips now only appear on rule rows.
  • Fixed an issue in our M Analyzer, ensuring that M functions such as Table.ColumnNames, Table.ExpandTableColumn, Table.ReplaceValues, and many of the Text.* functions, are now supported for offline schema detection (i.e. when performing an Update Table Schema while Use Analysis Services for change detection is disabled).
  • Fixed a bug that would cause an unhandled exception when attempting to resize the items in the Property Grid, while editing a property.
  • Fixed an issue in the M Editor where -- was incorrectly highlighted as a comment. In Power Query M, only // denotes a single-line comment.
  • Fixed an issue in the C# script editor where typing certain characters — such as a period, bracket, or digit — immediately after an auto-complete suggestion could cause the committed text to be duplicated or the wrong range of text to be replaced, due to an async race condition in the completion handler.
  • Fixed an unhandled NullReferenceException crash in the DAX Debugger Call Tree when expanding or clicking on nodes for iterator functions such as SUMX, MAXX, or MINX. After dismissing the error, the Call Tree would become unresponsive until Tabular Editor was restarted.
  • Fixed a bug in offline schema updates where unsupported M functions in nested shared expressions were silently ignored, leading to silent failures to update table schemas for partitions referencing these shared expressions. Now such functions are reported to the user

Coming from Tabular Editor 2.x?

Watch this video to get a quick tour of the main 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
  • DAX Optimizer integration
  • Code Actions to easily refactor you DAX.

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