Skip to main content

New Features and Improvements

AtScale contains the following new features and improvements.

Note

C2026.6 is a short-term support (STS) release. For more information, refer to the AtScale Product Lifecycle Support Policy in the Help Center.

C2026.6.0

MCP Server enhancements

The MCP Server now has improved AI BI grounding and accuracy for NLQ.

Note

The AtScale MCP Server is a Public Preview feature.

Four new tools give agents a better workflow when interacting with the MCP Server:

  • search_columns finds the governed name for a concept by keyword. This includes packaged calculations, so a search for "YTD" surfaces the calculation group.
  • validate_query confirms that a query's columns sit on compatible paths before executing, catching a query that would fail or return NULLs before any data warehouse credits are spent.
  • run_queries batches up to ten SELECTs into a single call.
  • get_version reports the server build.

The deeper improvement is in the query path. run_query used to pass SQL straight through to the engine; it now validates every query against the model's column_groups, which list_models returns as of this release. Incompatible metric and dimension combinations, or the wrong hierarchy level, are rejected with a validation error instead of running to a wrong or empty result. In practice, an agent makes a few more read-only calls before it queries, and returns fewer answers that look right but aren't.

Nothing in this release breaks an existing integration. The three original tools keep their names and call shapes, path validation applies without any client change, and authentication and transport are untouched.

For more information on the MCP Server tools included in this release, see the C2026.6 Tools Reference.

New server-side DAX functions

AtScale now supports the following server-side DAX functions:

  • DATE
  • DATEDIFF
  • DATEVALUE
  • NOW
  • TODAY
  • UTCNOW
  • UTCTODAY
Note

Server-side DAX language support is a Public Preview feature.

For more information, see Server-Side DAX Reference.

ATSCALE-43612

DAX model-specific connection strings now available in AtScale Connection Portal

Microsoft Power BI users can now obtain DAX model-specific connection strings from the AtScale Connection Portal. These strings are used to connect to Microsoft Power BI with the Tabular 1600 dialect. For more information, see Using AtScale Models in Power BI Composite Models and Using Power BI with Field Parameters.

ATSCALE-47329

Design Center enhancements

The following enhancements have been made to Design Center:

  • Objects on the model and dimension Canvases are adjustable by width.
  • Changes made to an object's width and height on the Canvas persist if you refresh your browser or log out of Design Center.
  • When you rename or duplicate an object (such as a model), its current Canvas arrangement persists in the renamed/new file.
  • The current state of the sidebar (whether it's expanded or collapsed) persists if you refresh your browser or log out of Design Center.
  • The state of object properties panels (whether they're expanded or collapsed, or have been resized) persists across all objects. For example, if you open a model, decrease the width of its properties panel, then open a dimension, the Dimension properties panel is the same width as the Model properties panel.
  • The state of sections in object properties panels persists across all objects of the same type. For example, if you collapse the Hierarchies section in the properties panel for one dimension, it remains collapsed in the properties panels for all other dimensions.

ATSCALE-45572, ATSCALE-44921, ATSCALE-47573, ATSCALE-47397

Descriptions for calculated members now populated based on calculation templates

Descriptions for calculated members of calculation groups are now automatically populated based on the selected calculation template. This information is helpful to LLMs, as it enables them to understand each member's purpose. Note that you can edit the prepopulated description if you want to provide your own.

For more information, see Add Calculation Groups and Calculated Members.

ATSCALE-47627

New aggregation type for metrics

AtScale now supports the Count If aggregation type for metrics. Count If metrics return the number of records that satisfy a condition (or NULL, if no records satisfy the condition). For more information, see Non-Additive Metrics and Add Additive or Non-Additive Metrics.

ATSCALE-45003

Unrelated Dimensions Handling now defaults to Include empty cells in query results

The default Unrelated Dimensions Handling setting for metrics has changed from Display an error message and return nothing to Include empty cells in query results. As a result, queries that previously failed because the inbound query or calculation combined a metric that was not related to a dimension will now execute and return an empty cell.

Note

This change may result in the execution of more queries and a proportional increase in data warehouse load and/or engine processing time.

For more information on unrelated dimensions handling, see About Queries on Dimensions that are Unrelated to One or More Queried Metrics.

ATSCALE-47535

New default role in the Identity Broker

The Identity Broker contains a new metadata_access realm role, which is automatically assigned to the xmla-service-account user. This role grants the xmla-service-account user XMLA metadata discovery permissions without requiring access to the data warehouse. This is required for Microsoft Power BI Gateway connections with service tokens.

For more information, see Identity Broker Default Roles.

ATSCALE-49115