DAX Studio 3.6.1

Fixes

• Fix #1479 Fluent.Ribbon v11 theming and UI inconsistencies
• Fix #1481 OneLake path handling for table names containing special characters and paths copied from Warehouse table properties
• Fix #1486 Server Timings labels and tooltips
• Fix #1488 Simplified Ribbon spacing and sizing
• fixed OneLake authentication token scopes
• fixed stale column and table names in ERD diagrams
• fixed query trace completion and query plan capture
• improved Excel add-in launch and logging compatibility

DAX Studio 3.6.0

Updates

• added the Delta Analyzer preview for inspecting Delta table metadata behind Direct Lake models
• added the Browse Workspaces preview
• added the benchmark command to dscmd (thanks @savoy9)
• added support for DAX user-defined functions when expanding measures and dependencies
• added secure, deterministic Entra account selection and non-interactive authentication to dscmd
• added the dscmd auth command for caching, listing, and validating Entra accounts without exposing access tokens
• made daxstudio and dscmd command-line arguments case-insensitive and consolidated parsing on Spectre.Console.Cli
• moved version notifications into the main window and added opt-in preview release notifications
• added search to File > Open and improved the Browse Workspaces experience
• added bulk Order By controls to the Query Builder
• added multi-row copy support to the Physical and Logical Query Plan panes
• added zoom support to the Server Timings and Custom Trace panes
• updated Fluent.Ribbon to v11
• updated the DAX Formatter endpoint, migrated to Microsoft.Data.SqlClient, and replaced WebRequest/WebClient with a shared HttpClient
• improved startup responsiveness by loading query history asynchronously
• improved View As reconnect and trace handling
• converted the solution to SDK-style projects with .NET Framework and .NET 8 builds
• updated the installer to overwrite all files during upgrades

Fixes

• Fix #1453 code completion for object names containing numeric digits
• Fix #1456 multi-row copy in query plans
• Fix #1458 bulk sorting adjustments in the Query Builder
• Fix #1460 callbacks without parameters not being highlighted
• Fix #1477 incorrect less-than-or-equal and greater-than-or-equal symbols in data grid filters
• fixed escaped callback names in the xmSQL parser
• fixed search in the database dialog
• fixed expired Entra access tokens and silent refresh behavior for ADOMD and trace connections
• fixed View As reconnect races, remap caching, and stale busy states
• fixed the save prompt when closing modified document tabs
• fixed the trace column cache not refreshing after reconnecting
• fixed an edge case with Server Timings and Clear Cache on Run when events arrive out of order
• fixed group column alignment
• fixed benchmark authentication to use the shared dscmd Entra flow
• fixed dscmd dependency binding errors
• fixed crashes in DAX Studio Checker, hotkey validation, and invalid window handling
• fixed WPF render-thread COM errors and a shutdown race
• fixed a race condition when building the options list
• improved opening SQL Profiler and Excel version detection

DAX Studio 3.5.2

Updates

• removed unneeded dependencies
• improved app startup performance
• improved performance when opening large daxx files
• improved server timings row highlighting

Fixes

• Fix #1439 adding FUNCTION as a keyword
• Fix #1440 parquet export failing with method or operation not implemented
• Fix #1442 errors in dscmd when using special characters in connection string
• Fix #1443 hang on server timings with extremely long lines
• Fix #1444 Query Plan not updating after being hidden
• Fix #1445 SQL Profiler not detected when using SSMS 22
• Fix #1446 Repeat calls to Capture Diagnostics failing
• Fix crash when copying hyperlink in error logs

DAX Studio version 3.5.1

Fixes

• Fixed #1438 error authenticating to myorg

DAX Studio version 3.5.0

New

• Added support for expand/collapse in query plans
• Added syntax highlighting to SE events
• Adding ctrl+r support to maximize editor view (#863)
• Adding support for UDFs in code completion and Functions tab
• Adding support for custom calendars in code completion
• Moved indent based code folding out of preview status

Updates

• Updated dependencies including v19.113.2 of AMO / ADOMDClient

Fixes

• Fixed #1414 Export data to parquet shows incorrect progress count
• Fixed #1415 export to parquet saving partial results
• Fixed #1417 update ODC name when exporting live connection to Excel
• Fixed #1421 allowing the use of guid or tenant name when establishing b2b connections
• Fixed #1434 updated code signing timestamp server
• Fixed #1427 EvaluateAndLog trace can break when logging tables
• Fixed #1424 typo in error message
• Fixed #1425 export to excel not able to be read by power query
• Fixed race condition that occasionally prevented metadata pane from loading when opening vpax file
• Fixed a rare startup crash
• Fixed async issue in benchmarks

TODO

[x] Test ERD arrow angles [x] field parameters in Diagram [x] Variations hidden in Diagram [x] fix colors for both themes on Diagrams [x] fix icons on light theme on Diagrams [x] add warning about UI changes to diagrams [x] remove env var

New

• Adding support for UDFs in code completion and Functions tab
• Adding support for custom calendars in code completion
• #1376 Adding parquet file export support
  • File results output
  • export data has a parquet option
  • dscmd FILE output supports .parquet output

Updated

• Clipboard handling improvements with re-tries
• improvements to Find/Replace dialog layout
• Adding support for SSAS 2025
• Improving the styling of Power BI Performance data
• #1405 Adding totals to Power BI Performance Data
• Added RequestID to trace information
• added FILE option to dscmd - this is an alias for the 'CSV' command, but the more generic name makes more sense now that we also support .parquet files
• Enhanced the ServerTimings tooltip to show event endtime and calculated duration (based on end - start)

Fixes

• Fix #1402 adding table name when defining formatstring expressions
• Fix #1403 prevent crash due to special characters in table/column names
• Fix cancel button not working on Multiple Queries Detected dialog when pasting from Performance Analyzer
• Fixes to close logic for FE Benchmark
• Fixing View As not working with dynamic roles against Power BI Desktop
• Fixed #1399 authentication 403 error when connecting to Sovereign Clouds

Updates

• Improved multi-threading when scanning for open Power BI Desktop files

Fixes

• #1396 Find/Replace dialogs not working
• #1400 dscmd not showing logging messages for errors

Updates

• Added option to show whitespace and control characters in editor
• Added SQL and TabularQuery filter buttons to Server Timings
• Added the accesstoken command to dscmd
• Right-click define measures / define dependent measures works when a query is selected and just defines the measures referenced in that query

Fixes

• Fix #1388 Statusbar timer reseting to 0:00.0
• Fixed race condition when opening file from command line parameter
• Fix #1389 close dialog button not working consistently
• Fix #1390 error with authentication for B2B users
• Fix #1392 including table name when defining measures
• Fixed History pane filtering when connected to Power BI Desktop
• Fix #1394 allow for name sorting in all Metrics views
• Fix #1395 updated clipboard retries and error display when using clipboard output
• Fix View Metrics incorrectly opening a second pane

Fixes

• Fix #1382 ServerTimings not working against PowerPivot
• Fix #1383 unable to connect to AzureAS (incorrect audience error)
• Fix #1381 renaming "Exit" to "Close DAX Studio" in File menu
• Fix #1385 removing sp_set_session_context calls when simplifying DQ query events

New Features

• DSCMD - added support for connecting to open Power BI Desktop files
• Added support for High Contrast Windows themes
• Added ObjectName to Server Timings
• Fixed #1361 displaying query errors in results area
• Fixed #1358 added line numbers to xmSQL pane
• Find/Replace in selection

Updates

• #1359 saving error message in Server Timings and allowing copying of error
• Improved EntraID auth in dscmd
• improved responsiveness while refreshing metadata against slow sources
• improved code folding logic
• Find/Replace - pressing Enter key will trigger find next
• Find/Replace - search while user types
• #1369 added tooltips to ServerTimings columns
• #1368 added right click copy / select all to vertipaq analyzer
• #1370 added tooltip to View As button
• Updated dependencies
• Updated .Net framework version to 4.7.2
• Improved Server Timings debug logging
• Improved handling of embedded line breaks in linked Excel output
• Improved trace startup timeout checks
• Improved reliability of Benchmarking and Capture Diagnostics
• Improved insertion logic when defining measures
• Improved backward compatibility when loading Server Timings
• Improved error squiggle location

Fixes

• Fixed #1332 Define Dependent Measure and Expand Measures not working reliably
• Fixed detection of FormatString property in results
• Fixed crash when launched from Excel but there is no active query window
• Fixed Server Timings timeline caching bug
• Removed duplicate Metadata Refreshed log messages
• Fixed #1324 All queries threading bug
• Fixed race condition in Benchmarking
• Fixed #1330 Improved Font zooming in editor
• Fixed bug setting query parameter values from XML
• Fixed #1336 trace start error when switching some connection types
• Fixed #1331 prevent code completion display for numbers
• Fixed #1323 adding support for // Query comments when pasting DQ queries
• Fixed opening daxx file from inside a zip file
• Fixed #1356 crash when defining measures from editor
• Fixed loading of daxx files from readonly locations
• Fixed incorrect validation error in Query Builder when loading non-string filters
• Fixed Find/Replace not working in QueryBuilder Measure Editor
• Fixed down arrow selecting from the database dialog
• Fixed #1371 File-Exit not triggering save changes dialog

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