DAX Studio

Posts relating to the DAX Studio project
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 ......

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

DAX Studio Parameters Dialog
I recently updated the documentation on daxstudio.org to include a page on the Parameter Support, but I thought this might also benefit from a longer explanation. It may surprise some people to hear this, but the DAX language has supported parameters in queries since it was first released. However while you can use parameters in a DAX query you cannot easily test parameterized DAX by supply the parameter values as variables like you can in T-SQL. In DAX the parameters are sent in a separate part ......

Posted On Tuesday, February 19, 2019 9:31 AM | Comments (0)

DAX Studio 2.8.1 released
So thanks to a couple of early adopters we’ve found and hopefully squashed a few bugs that managed to sneak into the 2.8.0 release and the 2.8.1 release is now live on https://daxstudio.org v2.8.1 Includes all the features from 2.8.0 along with the following fixes: Fixed a crash when launching DAX Studio by double-clicking on a .dax file (related to a race condition that only occurs in release builds) - thanks to @speschl for reporting the cause of this issue Fixed a crash when opening a file after ......

Posted On Wednesday, January 23, 2019 12:01 PM | Comments (0)

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)

Full DAX Studio Archive