20 posts tagged with "daxstudio"

This patch release improves the Delta Analyzer preview, fixes issues with discovering local Power BI Desktop instances, and includes several editor and tracing fixes.

This patch release addresses several issues introduced or identified following the 3.6.0 release.

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

Version 3.6.0 is one of the larger releases in a while. As well as a long list of fixes and performance work, it introduces the Delta Analyzer - a new preview tool for looking at the Delta table metadata sitting behind a Direct Lake model. This post also covers the two diagramming features that arrived in v3.5.0 but have not been written up until now.

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

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

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
• fixing crash when closing certain dialog boxes

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

If you select an entire query and choose the option to Define measures or Define dependent measures

DAX Studio will then inject all the measures reference in the query

you can see that:

1. the measure that is referenced directly in the query has been defined
2. the dependent measure has also been defined

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 Power Pivot
• 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
• Fix #1387 View/Export metrics not working with non-default Entra account

Today we are happy to announce the release of version 3.3.0 of DAX Studio which includes the following new features and fixes.