Updates

• Adding DAX parameter support to CSV & XLSX commands
• Improved Jumplist integration

Fixes

• #1292 grid output not binding results with > or & in the column name
• #1293 Vertipaq Options dialog learn more link broken
• #1298 Adding Advanced XLSX output settings in Options
• #1302 Fixing DirectLake mode option not working in View Metrics dialog
• #1305 All Queries not capturing events
• #1306 dscmd VPAX command not using default value for StatsColumnBatchSize
• fixing crash on exit

Updates

• Improving Smart Paste
• #1288 Added Support for View Metrics StatsColumnBatchSize
• Added sorting to ViewAs roles
• Fixed styling so trace command bars are not blurred

Fixes

• Fix caturing server timing events when Auto ClearCache is active against powerbi:// endpoints
• Fix #1284 dscmd CSV command not working with --connectionstring option
• Fix #1283 dscmd export command --tables option parsing
• Fix #1282 QueryBuilder measure renaming not working
• Fix #1289 dscmd CSV command error when exporting some queries
• Fix sizing of status bar server name tooltip

This is a minor fix to the v3.1.0 release

Fixes

• Fixed #1279 error sending results to static Excel output

New Features

• Added Capture Diagnostics
• Added Evaluate and Log trace
• Added Database dialog when connecting
• Added command line support
• Added Model Metrics / Vertipaq Analyzer Options dialog
• Added support for obfuscated model metrics
• Added support to Server Timings for the new ExecutionMetrics event

Improvements

• #1204 made listview selected row color lighter to improve the contrast
• #1124 Improved labelling of the zoom level
• #1241 Added "learn more" link to connection dialog
• Added storage mode column to the Partitions tab in View Metrics
• updated TOM, ADOMD and other 3rd party dependencies
• Fixed the images for the Server Timings event type filters
• Moved Server FE Benchmark out of preview status

Fixes

• Fixed a crash trying to show fonts in the option dialog
• Fixed #1213 Formatted file export not applying formatting
• Fixed loading of AggregateRewrite events in saved Server Timings
• Fixed occasional crash when using publish functions
• Fixed #1228 Query Builder not respecting delimiter setting
• Fixed #1179 reconnect active traces on connection retries
• Fixed an issue in QueryBuilder when loading a saved query containing a hierarchy
• Fixed an issue in QueryBuilder when trying to filter on a query scoped measure
• Fixed an issue where the Ribbon buttons get stuck in a disabled state after an error while a trace is active
• Fixed #1262 ViewAs not working with "Other User" option against the Power BI Service
• Fixed #1264 Status bar timer stopped too early
• Fixed #1268 where the View As dialog did not work properly with a large number of roles

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

Fixes

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

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

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

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

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

Fixes

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

Fixes

• Fix #963 missing shortcut icon

Fixes

• Fix #952 Run only selected text

Fixes

• Fix #952 Only run selected test

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

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

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

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

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

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)

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"

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

Includes all the updates from v2.14.0

Fixes

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

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
  • Updating link in help ribbon to Analysis Services forum
  • Adding link to Discussions https://github.com/daxstudio/daxstudio/discussions
• 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

Fixes

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

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

Fixes

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

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

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

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