As of v2.7.0 you can enable diagnostic logging in DAX Studio by holding down the left SHIFT key while starting the application. If you are having issues with the Excel addin you need to hold down the SHIFT key while Excel is starting up.
Logs are stored in the
%APPDATA%\DaxStudio\log folder. You can either paste this address into the Windows Explorer address bar or the Help - About window also has a link to this location.
Note: the following sections are included for completeness, but holding the
SHIFTkey at startup and the functionality now available in DAX Studio Checker supercedes the need to manually enable logging or check dependencies
You can manually enable detailed application logging by enabling serilog in the daxstudio.exe.config file.
The start of the daxstudio.exe.config file looks like the following:
To capture a detailed application log perform the following steps:
<!--comment start from before the
<appSettings>tag and the
-->comment end tag from after the </appSettings> tag
pathFormatsection to point to a folder on your system
<!--start and end
-->comment tags back to switch off the logging
Same as above except the config file is called Daxstudio.dll.config
Note: The start-up fusion logging detailed below can now be more easily enabled and disabled using the DAX Studio Checker tool
If Dax Studio fails to even start up this often points to a problem with the dependencies. If this is the case the application crash happens before the application logging above is initialized so it is not able to trap the error. To capture these issues we need to enable a feature of the .Net called “Fusion” logging. Fusion is the part of the .Net framework that finds and load dependencies.
Start by creating a text file on your desktop called FusionLogOn.txt and paste the following code in
Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Fusion](HKEY_LOCAL_MACHINE_SOFTWARE_Microsoft_Fusion) "LogFailures"=dword:00000001 "LogPath"="d:\\data\\fusion\\"
Note that the back slashes need to be doubled up and that the LogPath should point to an empty folder (Fusion will create a sub-folder with a file for each binding error.
Then rename the file from a .txt extension to a .reg - the icon should change to document with a stack of blue cubes next to it. Double-clicking on the .reg file will merge these settings into your registry.
Then try to run DaxStudio once, it should generate some logs files in the folder you specified. These are just htm files and you can view their contents with any text editor.
After this it’s important to turn the Fusion logging off as it is a machine wide setting that will log the start up of any .Net program
To do that create a text file called FusionLogOff.txt with the following content
Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Fusion](HKEY_LOCAL_MACHINE_SOFTWARE_Microsoft_Fusion) "LogFailures"=dword:00000000
And then rename the extension from .txt to .reg and double click the file
You can then zip up the contents of the log folder and add it as an attachment to an issue.
Note that there should always be some output from the Fusion log as there is an optional theme that the AvalonDock component looks for which is not used in DaxStudio.