Tabular Editor 3: July 2024 Release

We are excited to introduce the new version of Tabular Editor 3, which is available now. This month, we have significantly boosted the Pivot Grid to make it faster, more efficient, and reusable across models. Additionally, we have added the feature that all developers publicly diss but secretly desire: Export to Excel/CSV!

Make sure to head to our downloads page to get the newest release.

You can also take a look at this release’s features in this video:


Save Pivot Grids

You can now save Pivot Grids and reuse them across semantic models. This feature enables easy and consistent validation and testing of your DAX measures and models. The Pivot Grid layout will be saved in its entirety—columns, measures, rows, filters, etc. Reopening a saved Pivot Grid can, for example, be useful when investigating differences between a development and test model. A nifty feature we have added is that even if a measure has been renamed in the development model, the Pivot Grid can be opened in the test model without having to recreate anything – the Pivot Grid will use the name for the measure that is applicable in the open model.

If fields in the saved Pivot Grid do not exist in the model where you open it, a friendly warning will notify you about the missing fields. The warning helps you identify which fields are removed automatically from the layout.


A current limitation to saving Pivot Grids is that the conditional formatting will not be saved. This will be fixed in a later release.

Pivot Grid overhaul

The Pivot Grid has been revamped, adding a performance boost, a new default field list, and the ability to use hidden fields in the semantic model. Additionally, the Pivot Grid has a new and improved Field list that makes it much more intuitive.

Figure 1: Pivot Grid Field list

The areas in the field list are used in the following manner:

  • The Data Area is where you place measures or KPIs.
  • The Row Area and Column Area let you slice the data by columns or hierarchies.
  • The Filter Area is used to filter the data based on values in columns or hierarchies

You can still build the Pivot Grid using the old experience. To do so, right-click a field from the TOM Explorer and add it to the Pivot Grid.

A long-standing limitation of the Pivot Grid has been that hidden measures or columns cannot be used. We are pleased to announce that with this overhaul, this limitation is in the past.


Columns without an attribute hierarchy (Available in MDX = false) cannot be used in the Pivot Grid and are not shown in the Field list.

Please read all the details on our documentation guide to Pivot Grids

Export to CSV/Excel

Sometimes, you just need to excavate the result of a DAX query to understand what you have produced row by row, and there is, after all, no other tool for that than Excel. Based on highly secret and anonymized user requests, we’ve added a convenient button to the DAX query toolbar, allowing you to effortlessly export the results to CSV or Excel format.

Figure 2: Export Data button in DAX Query toolbar

So, the next time your boss requests to “review the detailed data,” you have a simple and convenient method to do so. 😁


To Export more than 1001 rows choose “click to get all rows” after running the DAX Query.

Bug Fixes

In Tabular Editor 3.16.0, we have implemented numerous bug fixes to improve the software’s performance and stability. Please refer to our release notes for a detailed list of all the fixes.

DAX Formatting Keywords

Unquoted table name references that are also DAX keywords, such as `Currency`, will no longer be treated as keywords during auto-formatting. This means they will not be capitalized.

Additionally, certain object properties in DAX scripts can now be left empty. For more information, see the updated DAX Scripts documentation.


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

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top