The latest release of DAX Studio is now available with the following new features and fixes.
Added Sponsor page to daxstudio.org
We are now able to accept sponsorship via Github Sponsors. If you would like to make a financial donation to support the continued development of DAX Studio you can now sponsor the project at https://github.com/sponsors/DaxStudio
Added preview Data for tables and columns
A new right-click menu has been added to tables and columns which will display a preview of the first 500 rows of data.
Extended Parameter Support to data types other than text
Previously parameters were always passed through as text based parameters. As of v2.16 you can now specify the data type for your parameters. This support is available both in the parameter dialog and in the XMLA parameter blocks.
When you specify @parameters in your DAX queries they will still default to the string data type, but there is a new dropdown which allows you to change this to one of the other supported datatypes (this list matches the parameter data types supported by Report Builder and Power BI Report Builder)
And if you choose the Write Parameter XML button or if you capture the query parameters using the All Queries trace those data types will also be reflected in the XML parameter block.
Added new version notification in title bar
When a new update is available there will be an update flag in the top right of the application and clicking on that flag will take you straight to the download page for that version.
Updated xmSQL cleanup to also fix table names
In the previous release of the xmSQL update feature we were cleaning up column names to match the display names, in this release this functionality was extended to also clean up table names.
Supporting all of the /f /s /d command line parameters at the same time
DAX Studio has always had support for the following command line parameters
/f <filename> – to open a .dax file /s <server> /d <database> – to connect to a server and database
But prior to this release you could only use /f on it’s own. As of this release you can use all 3 of these parameters together.
Query Builder Enhancements
The Query Builder has a number of new features in this release which are outlined below.
There is a new Clear button at the top of the Query Builder which gives you a convenient single click to clear everything from the Query Builder.
Now when you drag a column which has a Sort-by column the sort by column is added to the output list (this is required to support the next item)
There is a new Order By pane, this is collapsed and all columns are sorted in ascending order by default.
But you can expand this section and click on the columns there to switch them between sorting Ascending, Descending or ignored.
There is a new Auto-Generate button. When you click on this button the query generated by the query builder will appear in the edit window and will be updated in real time as you make changes to the Query Builder
Clicking the Edit Query button will now update any previously generated query rather than adding a new version underneath.
Extending installer support for Windows ARM64
The installer used to do a platform check for x86 or x64, this has been extended to allow installing on ARM64 since that platform now has an x64 emulation layer.