Skip to main content

Full Change Log

v3.0.11

Updates

  • Improved Query Folding logic
  • updated vpax libraries
  • fixed #1189 no longer counting RowNumber as user column in vertipaq analyzer
  • updated vpax libraries
  • updated TOM / ADOMD libraries

Fixes

  • fixed #1200 "An item with the same key has already been added" error when connecting to Power BI
  • fixed #1188 error when testing roles on SSAS
  • fixed bug in status bar for powerpivot connections
  • fixed #1180 detection of multiple parameters on one line
  • fixed #1178 Query Builder new measure showing permissions issue
  • fixed #1172 vertipaq analyzer summary always shows unknown.pbix
  • fixed #1171 error when loading perf data
  • Fixed Query Folding crashes with certain regional settings
  • fixed #1170 cancelling closing DAX Studio also cancels closing open documents
  • fixed #1169 error when opening files with Query Builder open

v3.0.10

Fixes

  • Fix crash dialog that appears when connecting or changing tabs when the Indent Based Folding preview feature is NOT enabled

v3.0.9

Updates

  • Updated Vertipaq Analyzer libraries to work with DAX Optimizer
  • Preview Feature - Indent Based Code Folding

Fixes

  • Fix Saved Server Timings not loading
  • Fix add escaping to find references
  • Fix define measure in calculation groups
  • Fix < typo in Query Builder
  • Fix Sorting by Translated Names
  • Improved DQ formatting

v3.0.8

Updates

  • Improved metadata refresh against Fabric Direct Lake models
  • Include dynamic format string in Define Measure
  • Added winget publishing to release pipeline
  • Fixed #1130 added hierarchy support to Query Builder
  • Fixed #1135 allows for dragging entire tables to Query Builder

Fixes

  • Fixed #1099 Rendering issues in View Metrics
  • Fixed #1104 assembly signing in automated build process
  • Fixed #1105 bracket highlighting for CallbackDataID in Server Timings
  • Fixed #1111 prevented multiple trace windows when opening files
  • Fixed #1119 Query Builder not saving if user has read-only access
  • Fixed #1120 clear any previous errors at the start of Server Timings trace
  • Fixed #1123 corrected spelling of Power Pivot
  • Fixed #1126 recovering multiple documents can set the wrong active document
  • Fixed #1128 right-click copy in results was incorrectly copying all cells
  • Fixed #1136 error when using data export to SQL and column name has square brackets
  • Fixed crash in hierarchy tooltip
  • Fixed crash reports
  • Improved autosave clean up
  • Fixed display of database name when connected to PBI Desktop
  • Improved autosave cleanup
  • Fixed bug in expand measures

v3.0.7

Updates

  • #1094 delete items from server list
  • #491 Clear Log and Clear Results context menu options
  • Added a preview option for exporting Server Timings text to separate files

Fixes

  • #1092 fix for spelling mistake in installer option
  • #1076 fix for xmlReader in use errors
  • #1077 incorrect hash calculation
  • #1080 fixed issue with line comments when using linked Excel output
  • #1081 min/max not populating in tooltips for some DQ models
  • #1083 fixed linked Excel output not working with AAD authentication
  • #1084 fixed crash on ctrl+shift+c
  • #851 fixed Object not set error in Query Builder
  • Fixed an issue loading older versions of ServerTimings data
  • Fixed issues relating to a couple of reported crashes

v3.0.6

New Features

  • #861 adding SHA256 hashes for downloads
  • #866 added copy with/without headers option for query results
  • #973 Added Duplicate option to tab right-click menu
  • #1016 open a .dax file by dragging it onto DAX Studio
  • #1031 adding encoding option for custom CSV output
  • #1051 added Formatted File as an output option
  • added json option when outputting to a file
  • FE Benchmarks
  • Updated Timeline/Waterfall visualization in Server Timings
  • xmSQL / DirectQuery formatting improvements
  • moved preview and vertipaq analyzer settings from the advanced to the standard options page

Fixes

  • #1062 fix vertipaq analyzer showing in summary pane for AAS / PBIP
  • #1060 enabling Shift+Enter to be used as a custom hotkey
  • #1052 disabled re-ordering of columns in vertipaq analyzer
  • #1036 fix location of desktop shortcut file for Current User installs
  • #1030 QueryBuilder measures missing table references when loading from file
  • #1029 QueryBuilder IN filters not loading from file correctly
  • #1026 improving VertiPaq Analyzer tooltips
  • #1025 fixing spelling / capitalization errors
  • #968 Tool Window incorrectly docking
  • #967 permission error on non-admin install
  • #979 improved color contrast in dark mode
  • #994 adjusted measure icon position when vertical scrollbars are always displayed
  • #997 adding support for measure filters in Query Builder
  • #999 fixed display of columns with open parenthesis as first character
  • #951 moved Swap Delimiters / Debug Commas to advanced
  • fixed metadata display for multi-dimensional models
  • skip showing crash dialog if app is shutting down
  • Improved generation of Define Measure and Define Dependent Measures
  • Fixed crash in BindableFocusBehaviour and AutomationPeer
  • fixed cell alignment in View Metrics columns tab
  • Fixed crash on update flag click event
  • Fixed crash when browsing for a folder during CSV data export
  • improvements for FE duration calculation
  • added default file name when exporting bim from vpax
  • fixed the hidden table icon
  • fixed Excel tracing
  • fixed invalid button states after failed connection attempt

v3.0.5

Fixes

  • #965 Permissions error when installing for Current User
  • Fixed colors on Getting Started dialog
  • Fixed incorrect new version notification on initial install

v3.0.4

Fixes

  • Fix #963 missing shortcut icon

v3.0.3

Fixes

  • Fix #952 Run only selected text

v3.0.2

Fixes

  • Fix #952 Only run selected test

v3.0.1

Updates

  • Added query information button to traces
  • Updated Query History icons
  • #949 Exposed Theme/Mode setting in Options
  • Added MPARAMETER keyword to syntax highlighting

Fixes

  • Fixed #891 Error exporting to static Excel file
  • Fixed #889 crash when dragging trace windows
  • Fixed #886 incorrect link to tutorial in Getting Started dialog
  • Fixed #894 Define and Expand sometimes producing incorrect output
  • Fixed #924 username blank in All Queries trace
  • Fixed #930 increased default code completion window width
  • Fixed #931 automatically select all text in find/replace dialog
  • Fixed #906 improved waterfall layout in Server Timings
  • Fixed setting focus in the editor when changing tabs
  • Fixed file icon registration
  • Improved error handling around shutdown operations
  • Added extra hotkey validation rules
  • Fixed #916 added retry logic to all clipboard operations
  • Improved Power BI filename detection for non-English cultures
  • Removed unused dependencies and reduced installer/portable file size

v3.0.0

New / Enhanced

  • New modern skin
  • Dark/Light Mode support
  • View As support
  • Benchmark can run with ViewAs to test RLS impact
  • All Queries can be enabled with other traces
  • Added simplified ribbon view

Updates

  • #826 added PowerPivot model detection timeout in options
  • Updating syntax highlighting to handle multi-line strings
  • Added highlighting of cache nodes in physical query plans
  • Improved state tracking for trace windows
  • Prevented interleaving of clearcache with query execution

Fixes

  • Fixed #764 error when running from cmd prompt
  • Fixed #799 error when opening querybuilder files from older versions
  • Fixed #812 FIPS compliant hash
  • Fixed #816 database dropdown too small
  • Fixed #838 added support for custom datetime formats when exporting to xlsx
  • Fixed #841 allowed for loading of performance data where component information was missing

v2.17.3

Fixes

  • Fixed #760 not loading the model metadata when the regional settings for the current machine uses something other than a period (.) for the decimal separator
  • Fixed a crash in the QueryBuilder when the model metadata has not loaded correctly

v2.17.2

2.17.2 fixes an issue where the automated build for 2.17.0 failed to sign the installer and includes the following updates from 2.17.0

New Features

  • Added Parameter support to Query Builder filters
  • Removing <pii> tags from xmSQL in Server Timings to improve readability
  • Fixing accuracy of Server Timings for queries with Batch events
  • Fixed #709 query builder queries are now captured in the query history
  • Fixed #747 the /f parameter can now open vpax files
  • Fixed #699 added extra information to the error message when the XMLA endpoint is not correctly enabled
  • improved caching of measure expressions

Fixes

  • Fixed #703 preventing a crash when entering a proxy password
  • Fixed #715 added DOUBLE data type to intellisense and syntax highlighting
  • Fixed #740 export to Excel failed on some machines
  • Fixed #755 saving parameters to XML was not correctly encoding special characters
  • Fixed #750 would crash on startup if the WMI information on the machine was corrupt
  • Fixed download link in Help - About screen

v2.16.2

Fixes

  • #662 Showing View Metrics Last Refreshed and Analysis Date in the local timezone
  • #659 When saving a file with the Query Builder open custom measure names were not saved
  • #663 Debug commas not handling lines with indented comments correctly
  • #664 Traces fail to start with a timeout error
  • #670 View Metrics - Last Refreshed date was incorrectly adjusting from UTC time

v2.16.1

Fixes

  • #657 Unable to open a new query tab either with a new connection or with a copied connection
  • #658 passing the database name on the command line
  • #647 hidden objects not hidden correctly when show hidden objects option was turned off (this was partially fixed in 2.16.0 but should work in all scenarios now)

v2.16.0

New Features

  • Added "Preview Data" right-click option for tables and columns
  • #580 extended Parameter support to include data types other than text
  • Added "New Version" notification in the title bar
  • Updated xmSQL cleanup to also fix table names
  • added sponsor page to github https://github.com/sponsors/daxstudio
  • #612 supporting all of the /f /s /d command line parameters at the same time
  • Query Builder Improvements
    • Adding Auto-Generate to Query Builder
    • Clicking Edit Query from the Query Builder will now update any previously generated query text
    • #570 Adding ORDER BY support to the Query Builder
  • Custom Key-Bindings moved out of preview
  • #620 Adding Ctrl+W to select current word
  • #584 Extending Hover tooltip to work with Keywords
  • #636 Show PBIX filename in the database dropdown instead of database ID
  • #638 Adding encoding option when using Exporting Data to CSV files
  • #632 extending installer support for Windows ARM64
  • updating ADOMD / AMO references to 19.22

Preview Features

  • Debug Commas - moves commas in formated queries to the start of the line
  • Show XMLA Commands in All Queries trace - shows commands sent by other tools like SSDT and Tabular Editor

Fixes

  • #578 Analyze in Excel not working with PBI XMLA or AzureAS
  • #579 Server Timings Layout Tab not appearing
  • Improved error message when no query text is specified
  • #581 All Queries Trace against PowerPivot caused crash
  • Fixed a crash when attempting to add a display folder to the Query Builder
  • Fixed a crash when attempting to use the query builder against a model with an invalid calculation script
  • #592 datatypes not syntax highlighted and not in code completion
  • #613 DMV and Function drag/drop not working
  • #647 Hiding hidden objects was not working correctly with items in display folders
  • #643 fixing issue with code completion window "sticking"

v2.15.0

New Features

  • #559 Added a toolbar button and right-click menu to copy Server Timing metrics
  • #556 Added an option to play a sound after long running operations
  • Added "Duplicate Measure" right-click menu to Query Builder
  • Added Error events to All Queries trace
  • #568 Added right-click menu option in the editor to go to dax.guide for functions
  • #569 Added Function tooltip display when hovering the mouse over functions in the editor
  • Added setup cmdline parameter docs
  • Added SQLBI videos to docs
  • Added discussions link to website navigation
  • Updated Multiple Query Detection to work with // Dax Query in addition to // SQL Query comments

Fixes

  • Adding extra checks around QueryEnd timeout in Server Timings
  • Close the Trace Layout ribbon tab when all documents are closed
  • Made 'Add New' disabled in the Query Builder if the current model has no tables
  • Fixed #458 added docs and tooltip to explain memory sizes
  • Fixed #517 updated clipboard bindings to allow for copying from the View Metrics tabs
  • Fixed #539 error starting traces when using Roles or EffectiveUserName
  • Fixed bug in retry for ViewMetrics when there is an error reading statistical information.
  • Added configuration to read statistical data for VertiPaq Analyzer. Disable reading statistical data for legacy versions of SSAS. Added retry logic and log of warning if there is an error reading statistical data.
  • Fixed #525 F1 and Context Menu to open dax.guide for functions
  • Fixed server timings trace for PowerPivot
  • Fixed drag drop issues with QueryBuilder
  • Fixed #514 Server Trace not working in Excel
  • Fixed #520 option to not truncate tables was not working when exporting to SQL Server
  • Fixed #511 Excessive metadata refreshes was causing metadata pane to collapse
  • Fixed #512 fixed Table tooltip warnings and added measure count
  • Fixed #546 corrected wording in error message
  • Fixed #549 correctly escape connection string values containing special characters
  • Fixed #557 delimiter error on Clear Cache when using non-US delimiter style
  • Fixed a bug with the Roles parameter in the advanced connection properties not accepting spaces
  • Fixed #563 metadata incorrectly resetting when using a combination of mouse selection and query builder hotkeys
  • Fixed #564 Application crashes when clicking on a ribbon tab while the ribbon is collapsed
  • Fixed crash when resetting key bindings
  • Fixed #575 autocomplete sometimes stops working
  • Disabled the Add Measure button when connected to a model with no tables
  • Fixed #576 Editing an existing Measure in Query Builder against PowerPivot causes a crash

v2.14.1

Includes all the updates from v2.14.0

Fixes

  • Fixed #509 - critical issue with the Excel Addin that causes it to fail to load

v2.14.0

Updates

  • Added help text when the edit control is empty
  • Added privacy settings
  • Added options for improving the readability of the xmSQL in Server Timings
  • Added "Multiple Queries Detected" dialog when pasting in queries from Power BI Performance Analyzer that came from a Composite model
  • Help Ribbon updates
  • Query Builder moved out of preview status
  • Benchmarking moved out of preview status
  • Enabled Discussions on the github site
  • Adding Query Builder documentation to daxstudio.org
  • Updating AdomdClient and TOM references to v19.14
  • Added retry logic when fetching Database and Model lists
  • #450 Last Updated is now shown in local time instead of UTC
  • Added keyboard short cuts in metadata pane to work with Query Builder
  • #492 added description to function tooltip

Fixes

  • Fixed crash when doing Replace All with an invalid RegEx expression
  • Fixed crash when clicking Refresh Metadata after connection has dropped
  • Fixed #469 Server Timings busy spinner was activating incorrectly when doing Clear Cache
  • Fixed #467 Database Name was being incorrectly injected into all new connections when DAX Studio was opened from External Tools in Power BI Desktop
  • Fixed #466 PBI XMLA connections not being parsed correctly
  • Fixed #457 crashing on startup after setting view hidden objects = false in options
  • Fixed #356 Clear Cache throwing errors against PBI XMLA endpoint
  • Fixed #449 Connection lost during Benchmarking
  • Fixed a trace timeout issue when connecting to PBI XMLA endpoint (sometimes it is still necessary to increase the default timeout to 90 seconds or more)
  • Query Builder
    • Fixed a bug when filtering dates that reported an error parsing an empty string
    • Added the ability to drag KPI components into the Query Builder
    • Fixed a crash when trying to alter the expression for a dynamic format string for a calculation group item
  • Fixed hang when pasting in code with extremely long lines (tens of thousands of characters)
  • Fixed #451 up/down keys not work consistently
  • Fixed #446 Aggregate rewrite events causing an error
  • Fixed #444 to use correct culture in csv export
  • Fixed #445 defaulting the selected model to the base model not the first perspective
  • Fixed an issue with the trace layout options not displaying
  • Fixed a bug with swap delimiters feature and block comments
  • Apply a number of small fixes that should address some issues that came in via crash reports, but these reports were all submitted anonymously so for many of them it is impossible to verify that the fix has worked as we have no steps to reproduce the issue and the fix is based on assumptions of the cause of the issue.
  • Fixed drag/drop of text not working within editor
  • Fixed #475 proxy auth error when entering AAD credentials
  • Fixed #485 Swap delimiters incorrectly affecting functions with periods in the name
  • Fixed #486 Define Measure not using Separator specified in Options
  • Fixed #497 Define Measures not working when connected to a model with active translations
  • Fixed #499 Added table name when querying for column references
  • Fixed #501 avoiding bug with EXCEPT function in Query Builder

v2.13.1

Fixes

  • #442 Crash when opening New Measure or Edit Measure in Query Builder
  • #440 Extended time out for clean up of temporary odc files

v2.13

New / Enhanced

  • Added native Excel output so that the Dynamic and Static Excel outputs are always available (event when running outside of Excel)
  • #340 Added "Clipboard" as an output target
  • Re-write of the connection handling to incorporate a retry mechanism if the connection gets dropped
  • View Metrics
    • Fixed Sorting in View Metrics table view to do a nested sort
    • Changed Sorting in View Metrics to sort Descending on first click
    • Added "loading" status to View Metrics
    • View Metrics - Fixed KB/MB/GB (it was lowercase, which is for bits not bytes)
    • Enhancement #403 View Metrics - added tooltips, loading indicator, fixed default sort
  • Query Builder
    • Improved the query patterns generated by the Query Builder
    • Added Between/In/Not In filter types to Query Builder
  • New Options view with search and categories to make finding options easier
  • Export Data now uses TOPNSKIP in million row batches allowing for the export of massive data sets
  • Enhancement #385 added an option to prompt before refreshing metadata
  • Changed default Text file output to UTF-8 csv
  • Renamed "Excel" button to "Analyze in Excel" in External Tools
  • Added a check that the portable version is not in a restricted folder

Fixes

  • Fixed #400 duplicate New option in customize Quick Access Toolbar
  • Fixed #401 unable to re-show Power BI Performance window after hiding it
  • Fixed #405 & #415 incorrectly trying to write external tools file when doing a non-admin install
  • Fixed crashes when right-clicking on certain tool windows
  • Fixed #411 Export to csv not quoting strings
  • Fixed #404 improved code completion interactions
  • Fixed #424 Parameter parsing in table constructors
  • Fixed #419 View Metrics error against PowerPivot models

v2.12.2

Fixes

#398 Exception thrown on startup. Only occurs when there is no history of previous data sources.

v2.12.1

New Features

  • Pasting a connection string into the server name will parse out the Data Source and Initial Catalog settings

Fixes

  • #391 - issues when copying Power BI Performance data and pasting into Excel
  • #393 - application crashed if you attempted to open the Initial Catalog list before specifying a server
  • #394 - output to text file was not working for multiple results sets
  • #397 - "All Queries" trace was not working against PowerPivot connections

v2.12.0

New Features

  • Installer now signed with an EV certificate (kindly funded by SQLBI) this should prevent/minimize warnings from SmartScreen
  • Added "Initial Catalog" setting to the Advanced Options in the connection dialog, if you have a very large model or slow connection (like AzureAS or VPN) then you can now choose the initial database you are connected to.
  • Added Roles and IsAdmin properties to Database tooltip
  • #382 Changed "Format Query" to a split-button so that you can choose the style of formatting by clicking on the bottom half of the button
  • Adding Portable build as a download option

Fixes

  • #378 Power BI External Tools - installer not correctly updating path in daxstudio.pbitools.json file if a non-default install location is used
  • #377 exporting tables with no rows would throw an error
  • #376 autosave not recovering open files for all types of crashes
  • #374 improved tooltip sampling to prevent full column materialization
  • Fixed crash when attempting to export using invalid manual connection string
  • #381 re-connecting to a pbix file that has been closed and re-opened after launching from External Tools does not work

v2.11.2

Updates

  • Adds support for the "External Tools" ribbon in Power BI Desktop

Fixes

  • #373 Fixes "Define Measure" when connected to a SSAS instance without admin rights
  • #372 Duplicate MyMeasures created when adding more than 1 custom measure in the Query Builder
  • #367 Measure information duplicated in VPAX files
  • Fixed crash when highlighting
  • Fixed crash when closing last tab and connection had been lost

v2.11.1

Fixes

  • Filters on datetime columns where we cannot parse the date value now report the error rather than crashing when using the "Edit Query" button
  • #343 Fixed spelling of KEEPFILTERS for IS NOT filters
  • #345 Comma placement changed to match the style used by DaxFormatter
  • #346 / #347 DaxFormatter now works in the Expression Editor
  • #351 error while exporting tables to SQL Server
  • #352 hierarchies in display folders not expanding
  • #357 leading/trailing comments missing when doing "define measure"

v2.11.0

New Features

  • (Preview) Query Builder
  • (Preview) Query Benchmark
  • #314 Added Quick Access buttons for New, New (with current connection) & Save
  • #277 Added Export button to all trace outputs
  • Added full filename tooltip to tabs (thanks @dmarkle)
  • Promoted View Metrics (Vertipaq Analyzer) from preview status to general availability
  • Promoted Export Data feature from preview status to general availability
  • Documentation Updates:
    • Added license page
    • including a section on SmartScreen issues in Win10 (thanks to Gilbert at fourmoo.com )
  • Updated syntax highlighting to align with DaxFormatter.com
  • Added a note in the Database tooltip that the Database Id can be copied using a right-click
  • Added formatting to shorten asazure: and powerbi: server names in the status bar so that the key information is visible
  • Added a partitions tab to the Model Metrics views
  • Added a sample of any missing keys to the relationships tab in the Model Metrics (these keys are not saved for privacy reasons when exporting to a vpax file)

Fixes

  • fixed cancelling of exports to SQL Server
  • improved keyboard navigation by adding IsDefault/IsCancel properties to dialog buttons (thanks @dmarkle)
  • fixed an issue with intellisense not re-enabling after reconnecting (thanks @dmarkle)
  • fixed an issue with Query History pane not updating the "Current" Database filter when changing databases
  • disabled external tools when connected to PowerPivot
  • #290 updated all URL references to use https (thanks @warthurton)
  • #291 fixed issue connecting from Excel 2010
  • #301 refined the code completion to prevent it overwriting code when editing in the middle of an expression
  • #302 disabled column re-ordering in Metrics view
  • #303 fixed an issue with the metadata pane when connecting to a model with dynamic format strings defined in calculation groups
  • #308 removed backtick characters in column names with spaces where using the Static Excel output
  • #320 fixed server not found error when exporting vpax file for PowerPivot models
  • #325 fixed error when attempting to connect to PowerPivot files stored on OneDrive
  • #329 fixed incorrect database name shown when launched from the Excel addin and not connected to PowerPivot
  • #330 fixed the status message getting stuck after writing output to a file destination
  • #339 fixed a bug that reported an assembly load error when Cancelling a query

2.10.2

This minor update includes a couple of small new features and a few bug and crash fixes.

New Features

  • #274 Adding Editor Word Wrap to options screen
  • #270 Added option to display current user in title bar
  • Added Dax Formatter option to omit spaces after function names

Fixes

  • fixed crash when selecting PBI / SSDT connection, but not selecting a file
  • fixed crash when running a query that produces no rows and using the Static Excel Output
  • fixed #272 Vertipaq Analyzer not working if any tables have a single quote in the name
  • fixed a number of reported crashes
  • improved a number of background threading calls to use the simpler async/await pattern
  • moved checking for schema changes on activating DAX Studio to a background thread to prevent the UI freezing for slow connections (AAS) or if there are active commit locks.
  • fixed an issue preventing diagnostic logging from working with the Excel addin

2.10.1

  • Fixes a bug with Publish DAX Functions