DAX Studio

Posts relating to the DAX Studio project
DAX Studio 2.8.0 Released
So it’s been a little while coming, but the 2.8.0 release of DAX Studio is now available at https://daxstudio.org It contains a host of new features as well as a lot of stability improvements. Below is a copy of the release notes. New Features: Filter Dump Measure – right-clicking a table in the metadata pane can generate a measure that returns a string describing the active filter context in a table or in all the tables. The DAX measure generated should be copied in a Tabular model to display the ......

Posted On Tuesday, January 22, 2019 9:45 AM | Comments (0)

DAX Studio – What do all those numbers mean in the server timing output?
When you run a query in DAX Studio with the Server Timings feature switched on you will see output like the following. A number of the metrics that are gathered by the server timings have been abbreviated and if you may not be aware of what they all mean. The topic of performance tuning DAX queries can get quite involved. This post is just designed to give a brief overview and bit of background about how the different metrics are calculated. Metric Description Total This is the total query duration ......

Posted On Sunday, January 20, 2019 10:17 PM | Comments (0)

DAX Studio recent Win7 SP1 crashes
We've just found out that a recent security update to the .Net framework in January 2018 for Windows 7 SP1 has been causing crashes in DAX Studio when accessing the File menu. Unfortunately this issue is outside of our control and affects any WPF based windows app which references the Windows Font collection (which DAX Studio does in the Options window)If this issue is affecting you the following link outlines the cause of the issue and some possible fixes https://github.com/dotnet/a... ......

Posted On Tuesday, February 6, 2018 7:08 AM | Comments (0)

DAX Studio 2.7.0 Released
The major change in this version is to the tracing engine. We’ve introduced a new trace type and made some changes to the way the tracing windows operate and incorporated some enhancements to crash reporting and enabling logging.We've also finished moving off our old codeplex home onto http://daxstudio.orgChanges to the way trace windows workPreviously when you clicked on a trace button, the window opened and the trace was started and when you switched off the trace the window closed. The running ......

Posted On Monday, October 2, 2017 7:57 PM | Comments (1)

DAX Studio 2.6.0 downloading issues
UPDATE: Looks like the 2.6.0a release on codeplex is now being flagged by Chrome as malicious. I don't know if it's the file or codeplex.com that is the issue (our older releases with thousands of downloads appear to now be falgged as "malicious" too now). So I have also made the setup file available as a release from our github repo too - https://github.com/DaxStudi... If you had trouble dowloading the 2.6.0 release yesterday there is now ......

Posted On Thursday, December 22, 2016 10:06 AM | Comments (1)

DAX Studio 2.5.0 Release
The next version of DAX Studio has just been released. You can download this release and read the release notes here Note: In this release we have updated the versions of the Microsoft ADOMD.Net and AMO libraries we reference to use the SQL 2016 versions. This gives us scope to access some of the new functionality in Power BI and SQL Server 2016, but may mean that you are prompted to download these when you upgrade from a previous version. Some of the highlights of this release are: New Features ......

Posted On Thursday, October 20, 2016 5:46 AM | Comments (0)

Dax Studio 2.3.2 released
This latest release includes a lot of UI polish features and we also now have support for SQL 2016 and Excel 2016 which is mainly an update to the installer and some changes to the Query Plan and Server Timings features to deal with some changes to the xmlSql that comes back in the trace events. Following the theory that a picture is worth a thousand words – below are screenshots of the changes in this release. The File –> Open menu now includes a list of recently opened files. For performance ......

Posted On Tuesday, November 3, 2015 11:10 AM | Comments (1)

DAX Studio 2.2.6 released
Just release an update to DAX Studio bundling up the following fixes and enhancements: Support for the upcoming release of Power BI Desktop Dynamic Ribbon resizing Remembering of Window size and location fixing display of hierarchies in Excel 2013 fixing quoting of keywords in table names fixing an error when duplicate column names are returned in a query fixing an issue when changing databases when connected to a Multi-Dim server fixing an issue when connecting as a non-admin I’m particularly happy ......

Posted On Friday, July 24, 2015 7:27 AM | Comments (0)