Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Aggregation Option Issue in Power BI Desktop with Azure Analysis Services

Hey all,   I'm currently doing a live connection from Azure Analysis Services to Power BI Desktop. The connection is successful and I see my dimensions and fact table showing up in the report.   ...
Need Help
Tips and Tricks
  • Icey's avatar
    Icey
    6 years ago

    Hi Anonymous ,

     

    Do you connect to Tabular or Multidimensional? 

     

    I tested with SSAS(on-prem).

    For Tabular, columns could be aggregated.

     

    But for Multidimensional, columns couldn't be aggregated. I'm not sure if it was possible before. 

     

    In your scenario, if last week, (1) it was connected to Multidimensional and (2) columns could be aggregated. But it doesn't work currently and you are a pro user, it is suggested to create a support ticket to get further help.

     

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

marcstoffels's avatar
marcstoffels
Helper I
5 years ago

I have the same issue, no aggregation options in Power BI Desktop for columns, when connecting to our tabular cube in Azure, using model 1500.
We migrated our tabular model from 1400 to 1500.
The 1400 model still shows the aggregation options in Power BI Desktop (October 2020 version).
Is this still an open issue, or is it with the 1500 version obligated to create a measure (on each column) in your model for aggregation purposes?

  • marcstoffels's avatar
    marcstoffels
    Helper I
    5 years ago

    I have found the answer here:
    https://github.com/otykier/TabularEditor/issues/636

    marcosqlbi commented Oct 3, 2020
    This is by design: calculation groups automatically disable implicit measures.
    However, using explicit measures is a best practice when you create a model you share with other users.
    Documentation: https://docs.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups?view=asallproducts-allversions

    This documentation:
    Calculation groups work with explicit DAX measures. In this example, Sales is an explicit measure already created in the model. Calculation groups do not work with implicit DAX measures. For example, in Power BI implicit measures are created when a user drags columns onto visuals to view aggregated values, without creating an explicit measure. At this time, Power BI generates DAX for implicit measures written as inline DAX calculations - meaning implicit measures cannot work with calculation groups. A new model property visible in the Tabular Object Model (TOM) has been introduced, DiscourageImplicitMeasures. Currently, in order to create calculation groups this property must be set to true. When set to true, Power BI Desktop in Live Connect mode disables creation of implicit measures.


    You can change this property to "false", but then the calculation groups functionality will not work:
    "discourageImplicitMeasures": true,


    So, this means indeed that we should create measures for each column to be aggregated.