Forum Discussion

100tsky71's avatar
100tsky71
Frequent Visitor
9 months ago
Solved

SQL Server 2025 and Visual Calculation

We have installed SQL Server 2025 and deployed an SSAS Tabular instance (version 17.0.25.218). We created a tabular model and set its Compatibility Level to 1700, which is the highest available ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 months ago

    Hi 100tsky71 ,

    Try below options.

     

    1.  Use a composite model, Connect to SSAS with DirectQuery for AS / Semantic Models, NOT Live Connection.

     

    Steps:

     

    Power BI Desktop → Get Data → Analysis Services

     

    Uncheck Live Connection

     

    Choose “DirectQuery for Power BI Datasets and Analysis Services”

     

    This creates a local model layer, and New visual calculation becomes active.

     

    This is the only architecture that currently works.

     

    2. Import underlying data instead of using SSAS

     

    If possible, build the model in Power BI (not SSAS).

    Visual calculations work immediately.

     

    3. Wait for Microsoft to update Desktop

     

    SQL Server 2025 only recently shipped.

    Visual Calculations for SSAS Live is real, but Desktop support is lagging.

     

    Expect this to light up in a future Desktop release.

     

    Note: Power BI Desktop November 2025 does not yet support Visual Calculations over Live Connection to SSAS 2025, even though the engine supports them. Live connection will not work until Microsoft updates Desktop.

     

    If my response as resolved your issue please mark it as solution and give kudos.

Anonymous's avatar
Anonymous
Not applicable
9 months ago

Hi 100tsky71 ,

Try below options.

 

1.  Use a composite model, Connect to SSAS with DirectQuery for AS / Semantic Models, NOT Live Connection.

 

Steps:

 

Power BI Desktop → Get Data → Analysis Services

 

Uncheck Live Connection

 

Choose “DirectQuery for Power BI Datasets and Analysis Services”

 

This creates a local model layer, and New visual calculation becomes active.

 

This is the only architecture that currently works.

 

2. Import underlying data instead of using SSAS

 

If possible, build the model in Power BI (not SSAS).

Visual calculations work immediately.

 

3. Wait for Microsoft to update Desktop

 

SQL Server 2025 only recently shipped.

Visual Calculations for SSAS Live is real, but Desktop support is lagging.

 

Expect this to light up in a future Desktop release.

 

Note: Power BI Desktop November 2025 does not yet support Visual Calculations over Live Connection to SSAS 2025, even though the engine supports them. Live connection will not work until Microsoft updates Desktop.

 

If my response as resolved your issue please mark it as solution and give kudos.