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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hey all,

 

Thanks for providing insights on how to best approach this topic. It seems like it's an issue that warrants a support ticket. The server is run on Azure Analysis Services, so it's set by default to be in tabular view. Screenshot below with sensitive information redacted.

 

 

I will work on using the Support Ticket system to get this resolved. Thank you everyone!