DAX Studio

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 ......

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 ......

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 ......

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 ......

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 ......

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... ......

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 ......

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 ......

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 ......

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 ......

News

Legal
Any and all code, software, examples, suggestions and anything else on this web site is available for you to use at your own risk. No warranty is expressed or implied.
Views and Opinions
The views and opinions expressed on this web site are not necessarily the views or opinions of my employer.