Tabular Editor Blog

Tabular Editor 3 July 2023 Release

Written by David Bojsen | July 21, 2023

We are happy to share with you the July 2023 version (3.9.0).
Even though it’s mid summer and everyone at Tabular Editor gets to take some time off with family and friends, we have still been hard at work to produce a new version to keep you as productive as possible. We hope you’ll like it.

If you can’t wait, head on over to downloads to get the release.

Table Of Contents

New features

Support for Azure Government Cloud and sovereign Clouds

Customers on one of the Azure for Government and sovereign clouds (Germany & China) can now specify the base URL that Tabular Editor 3 should use when connecting to the Power BI REST API.

An example is when you would import tables from a Power BI Dataflow by using the Tabular Editor table wizard. This setting is specified under Tools > Preferences > Power BI > Power BI Service.

Pivot Grid / DAX Query quick summary

When selecting more than one cell in a DAX query result or a Pivot Grid, we now show a summary of the values selected in the application status bar (sum, minimum, maximum, average, etc.). Hold down Shift/Ctrl to select ranges the way you’d usually do. Shift+click on a column header will select all cells in that column. See #475.

Improvements

Updated to use latest version of TOM/AMO/AdomdClient

We have updated the mentioned libraries from Microsoft that we use for connecting to Analysis Services and Power BI.
This should bring along a nice performance enhancement to the Pivot Grid component, when browsing your data.

Save model backup upon deployment and/or saving

We’ve added a separate option for saving zipped model.bim backups under Tools > Preferences > Model Deployment. You can now choose to have backups saved upon every deployment, upon every save (while connected to an instance of Analysis Services/Power BI), or both.
This also fixed issue #796.

NOTE

This feature is not available for Tabular Editor 3 Desktop Edition

Improved usability for Pivot Grids and Diagrams

It is now possible to add objects to Pivot Grids or Diagrams, even when those documents do not have focus (assuming no more than one such document is open).
Moreover, you can now create a Pivot Grid by right-clicking on a measure, saving a few clicks, when you just need to test the value of a measure.

NOTE

There is a known issue with the Pivot Grid component if you are trying to use hidden measures.
The current workaround is to unhide any measures you want to use in the Pivot Grid. You can hide it again when you are done.

Updates to Tabular Model Definition Language (TMDL)

We have updated to TMDL preview-3, the latest preview version of this new serialization language.
For more info about TMDL visit our May 2023 release blog.

NOTE

TMDL is still in preview, and as such, this feature must also be considered a preview feature of Tabular Editor 3.
Make sure to keep a Model.bim / Database.json backup of your model metadata to avoid losing work.

Several minor improvements

  • We’ve rearranged some of the pages and sections of the preferences dialog, making it easier to navigate.
  • When a calculated table is left with a blank expression, we now show the error icon immediately in the TOM Explorer.
  • VertiPaq Analyzer has been updated to version 1.2.18, and we’ve included additional info columns, to bring it up to par with DAX Studio.
  • When a calculated table is left with a blank expression, we now show the error icon immediately in the TOM Explorer.
  • We now show an error message if attempting to assign an expression that produces a value of type ‘Variant’ to a calculated column (this is not allowed).

Bug fixes

We have made multiple bug fixes and minor improvements in 3.9.0; please see our release notes for full details.

If you have any feedback or experience any bugs please reach out in our community forum. We look forward to hearing from you!
View full post