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