Skip to content

Tabular Editor 2.9.0
Compare
Choose a tag to compare
@otykier otykier released this 07 Dec 14:24
· 761 commits to master since this release
2.9.0
a22b810

It's time for another round of bugfixes and improvements.

Many thanks to the community for reporting issues so that I can keep improving Tabular Editor.

Calculation Groups

  • Calculation Groups have been greatly improved. Visually, they are now similar to the Tabular Object Explorer in SSDT:
    image
  • The Calculation Group Table and the columns on the table behave similarly in the UI as other tables and columns, meaning you can add calculated columns, measures, etc. Just keep in mind that Analysis Services doesn't support having more than 1 or 2 data columns, one with SourceColumn = "Name", and the other (optional) column with SourceColumn = "Ordinal". Tabular Editor creates these columns for you.
  • Calculation Items can be duplicated, batch renamed, reordered, copy/pasted, dragged and dropped - even between Calculation Groups - similar to other objects.
  • Calculation Items can now be serialised individually when using the "Save to Folder"-option (#367).

Import Table Wizard

  • The "Import Table Wizard" now finally implements the "Manually import metadata from another application" option (see issue #355). This option lets you paste in any kind of delimited text that specifies a table schema, and Tabular Editor will try to parse the text, to determine the list of columns and their corresponding data types. No more manual mapping of columns!
    image
  • The schema parser is pretty basic, but let me know if you have a specific scenario in which it doesn't work, and I'll look into it.
  • You may also simply enter the column names manually in the grid on the right. That might still be a lot faster than adding Data Columns in the main UI.

Bug fixes

  • #361
  • #369
  • #354
  • #357
  • #368
  • When saving a new model as a file, Tabular Editor will now properly apply the .bim extension, if it's not already specified.

Scripting

  • Table objects now expose two new methods: AddPartition(<name>, <query>) and AddMPartition(<name>, <expression>).

Other

  • Retargeted to version 18.2.3 of the TOM AMO libs
  • The Type column (when metadata information columns are displayed) now displays whether a table is using Import, DirectQuery or Dual mode. #356
  • Changed default compatibility level of new models to 1500 (SQL Server 2019 / Azure Analysis Services)
Assets 4