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.

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , what is the data type of Name. Is it a Measure?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hey amitchandak ,

 

Thanks for replying. The Name column currently shows a data type of "Text" and is a table column, not a measure. The aggregates showed up last week, but now they do not appear at the moment.

This issue also applies to other fields with a data type of "Decimal Number".