Documentation

Main Screen

The following image outlines the main sections of the DAX Studio user interface

1. Ribbon Control / File Menu
2. Metadata Panes
3. Query Editor
4. Output Panes
5. Statusbar

Current feature set

Dax Studio works as both an add-in for Excel 2010/2013 and as a standalone program and provides the following functionality:

• Modern User Interface
  • Flexible Layout
  • Multiple Tabs
  • Office 2013 like Ribbon Control
• Integrated Tracing
  • Query Plan Trace
  • Server Timing Trace
• New Version notification
• Single Installer

Proposed future feature set

We are always on the look out for new feature ideas. These are kept on the project’s issue list. You can vote for existing ideas/issues or add your own.

Troubleshooting

If you have issues running Dax Studio there are some logging settings that can be enabled to help diagnose the issue.

There is also a small utility called DAX Studio Checker which can help check the configuration of your machine. The links to the 3 external dependencies which Dax Studio requires are listed on the Installer page.

If you get the error “Not loaded. A runtime error occurred during the loading of the COM Add-in” for the Excel add-in you can try enabling the environment variable as detailed in these instructions https://www.oneplacesolutions.com/support/0053.html to display a more detailed error message

Credits

Dax Studio is using the following open source libraries, without these it would not exist in it’s current state:

• AvalonEdit - main editor control
• AvalonDock (part of Xceed WPF Toolkit - Community Edition) - Docking UI
• Caliburn.Micro - MVVM framework
• Fluent Ribbon - Ribbon control and Office 2013 window style
• Hardcodet NotifyIcon - version update notification messages