Export Underlying Data and Summarized Data

[Anonymous]

Currently Power BI visuals are giving same output when we export using  Underlying Data and Summarized Data using SSAS live connection.  Underlying Data has to give all measures from measure group and Summarized Data used to display the measures which we kept in visual but this is not happening from last 2 months.  We are getting measures available in the visual for both options when we export data.  Can you please confirm if this is the expected behavior.  Is there any updates to be done from our side so that both the data is exported differently.

[zuheirashraf17]

Hello, was this issue left unsolved?

I found this topic as I am having the same issue.. Data is connecting through AAS, underlying data and summarized export features giving the same result. Other report connecting to SQL DB seems to be working fine. 

[GilbertQ]

Hi there

I think this might be due to it being connected via LiveConnection to an SSAS instance.

Whilst if the data is imported to Power BI Desktop, it would then work as expected?

[Anonymous]

Thanks for your reply Gilbert. 

IN Power BI Service, when exporing data using Summarized Data, Data in the Visuals is exported.

When exporing using Underlying Data option, Other measures in the Measure group from Cube is not coming up post April.  Only data in the Visuals is again getting exported.

In Power BI Desktop, Only Export data option is available.  Data exported is similar to Summarized Data.

Was there any change in Power BI due to which different data is not getting exported for Summarized and Underlying Data options.

---

@GilbertQ wrote:
Hi there

I think this might be due to it being connected via LiveConnection to an SSAS instance.

Whilst if the data is imported to Power BI Desktop, it would then work as expected?

---

[GilbertQ]

Hi there

It would possibly appear then that when connecting to an SSAS Instance you can only get the summarized data?