Skip to content

Tabular Editor 2.12.1
Compare
Choose a tag to compare
@otykier otykier released this 29 Aug 13:26
· 515 commits to master since this release
2.12.1
3a72a28

Updates in Tabular Editor 2.12.1:

  • The following methods can now be executed globally (i.e. without prefixing them with Model.Database):
    • void ExecuteCommand(string tmsl)
    • IDataReader ExecuteReader(string dax)
    • DataSet ExecuteDax(string dax)
    • object EvaluateDax(string dax)
    • More information
  • Added the "TOP (without NOLOCK)" row reduction clause to the Import Tables Wizard. This is needed on Synapse SQL pools, since they don't allow the NOLOCK table hint. See also issue #582
  • Allowed creation of tables with M partitions even when no data sources have been defined, since M partitions can include data source and credential information inline.
  • Fixed issue with DataTable ExecuteDax(string dax) causing an error when nullable columns were returned.
  • ExecuteDax now returns a DataSet instead of a DataTable to allow for multiple EVALUATE statements in a single query.
  • The Output() script helper method now supports DataTables, to quickly visualise the result of a DAX expression obtained from ExecuteDax or EvaluateDax

Updates in Tabular Editor 2.12.0:

New features

  • Updated AMO/TOM to target latest version (v. 19.9.0.1)
  • Added support for editing table refresh policies
  • Added support for inline scripts in the CLI using the -S switch (simply type out the script as an alternative to specifying a script file name)
  • Added support for saving back to the source instance of AS using the CLI. Simply specify the -D switch without any additional arguments (this allows us to run a script against a Power BI Desktop model as an External Tool, see issue #530).
  • External libraries specified at the top of the script using the #r "library.name.dll" syntax are now resolved by looking in Tabular Editor's installation folder first and then in GAC.
  • Three new methods have been added to the Model.Database object. These make it possible to programmatically interact with the AS instance when model metadata have been loaded from a database. Expect to see some interesting examples of what these can be used for in the near future:
    • void ExecuteCommand(string tmsl)
    • IDataReader ExecuteReader(string dax)
    • DataTable ExecuteDax(string dax)

Bugfixes

  • Exception handling on AS trace clean-up
  • Fixed a bug where adding a level to a hierarchy and then subsequently undoing that operation could cause a crash
  • Fixed issue #565 - you now no longer need to enable unsupported Power BI features to be able to translate object names through the Explorer Tree
  • Fixed issue #557
  • Fixed issue #566 - measures that have the "Variant" data type (which may happen by adding certain calc group logic) now display the same format string options in the property grid, as if they had a numeric data type.
  • Best Practice Rules are now properly stored to the model annotations of a Power BI Desktop model
  • Fixed issue #568
  • Fixed issue #574
  • Fixed issue #575
  • Fixed issue #576
Assets 4