You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Fixed bug with column selector dialog that didn't always enable/disable the OK button. In addition, item names should no longer be truncated.
Changed tooltip delay from 5 to 20 seconds when cursor is hovered over the item that triggered the tooltip, issue #586
Added option for specifying a custom compiler for scripts (for example, if you have Visual Studio installed, you can use the Roslyn compiler to take advantage of new C# language features when scripting)
Added a new set of global helper methods for displaying an object selection dialog to the user SelectColumn(), SelectTable(), SelectMeasure() and SelectObject(). These methods are useful when creating reusable scripts, such as generic scripts for adding Time Intelligence to a model.
Updates in Tabular Editor 2.12.1:
The following methods can now be executed globally (i.e. without prefixing them with Model.Database):
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 #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