Forum Discussion

ysapiyev's avatar
ysapiyev
Responsive Resident
8 years ago

Data aggregation in SSAS live connection doesn't work

Hi everyone,

 

I have SSAS olap cube with live connection and I'm facing some troubles with data aggregation. All data aggregations as count of items, average doesn't work. What can be the issue for this cause?

 

Regards,

Yerkhan

Need Help

3 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi ysapiyev,

     

     

    All data aggregations as count of items, average doesn't work. 

    Do you mean the average measures display incorrect value in visual? Could you please show us the result you have got in Power BI desktop?

     

    Regards,

    Yuliana Gu

    • ysapiyev's avatar
      ysapiyev
      Responsive Resident
      8 years ago

      v-yulgu-msft,

       

      I meant this:

       

      Also, I couldn't insert text column in measure field to find count of this text column.

       

      Regards,

      Yerkhan

    • ysapiyev's avatar
      ysapiyev
      Responsive Resident
      8 years ago

      v-yulgu-msft,

       

      I meant, that I need average field in report. Did you have a chance to solve my request?

       

      Regards,

      Yerkhan