Monday, June 3, 2019 #

DAX Studio 2.9.0 Released

A new update to DAX Studio is now available at https://daxstudio.org which includes the following:

New Features

  • Import Power BI Performance Data
  • Support for Display Folders in the Metadata pane #127
  • Added options to enable/disable the automatic metadata refresh by connection type (local/network/cloud) #182
  • Option to hide hidden objects in the metadata pane #167 (can also be toggled from right-click menu)
  • PowerBI auto-date template and variation tables (as these can't be directly queried)
  • Option for metdata search to be pinned open #151
  • Option to increase width of intellisense window #152
  • Adding show referenced objects option on metadata right-click (thanks @DaveStabilify) #144
  • Option for setting 'Clear Cache and Run' as the default run style #86

Bug Fixes

  • Fixes #175 - Handling of quotes in csv export
  • Fixes #177 - Scrollbars not displayed in recent files list
  • Fixes #180 - error when tracing connections using Roles=
  • Fixed a bug where changing connections did not always update the selected database
  • Fixed issues with crash recovery of unsaved changes

Internals

  • Refactored unit tests and ADOTabular dll to allow unit tests to be run automatically during appveyor builds
  • Adding Database Name column to all traces to work with the new Power BI XMLA endpoint
  • Updating AMO/ADOMD library references

Import Power BI Performance Data

The new Performance Analzyer pane in the May 2019 release of Power BI Desktop

image

The new release of DAX Studio allows you to import the performance data exported from Power BI Desktop so that you can sort and filter the data as well as directly executing any of the queries in order to tune them in DAX Studio.

 image

Support for Display Folders

If you have placed any measures or columns into display folders this will now be reflected in DAX Studio

image

Show Referenced Objects

A new right click option is available on tables, columns and measures which will generate and run a DMV query that will show you what other things in your model reference the selected object. (thanks to a contribution on Github from @DaveStabilify)

In the screen shot below we have run this on the ‘Geography’ table and it is showing us that this table is referenced by an active relationship from the Customer table as well as a security role that has been applied to the [Country Region Name] column.

image

Option to Hide Hidden Objects

DAX Studio has traditionally always exposed all the objects in your data model, both hidden columns/tables/measures as well as the artifacts introduced by auto-date tables. But sometimes there can be a lot of these and they can just get in the way. Now you can toggle the display of them on and off and you can set a default for this in File –> Options.

image

New Options

A Number of new Options have been added in this release which have been highlighted below

image

Posted On Monday, June 3, 2019 3:09 PM | Comments (0)