Exporting underlying data from a table is the same like exporting summarized data

[CK1992]

Hi team,

I hope you are well.

I face the following issue when i am trying to export the data from a table in PBI service.

In the past, when we were downloading the underlying data, we were taking back the whole dataset. 

However, this does not work anymore. When I download the underlying data it is the same as downloading the summarized one.

Do you have any idea about this?

Thanks,

Christos

[GilbertQ]

Hi @CK1992 

You could go into the report settings and make the required change as shown below.

[CK1992]

Hi,

I have already done it.

The underlying is active but when you download your data they look like the summarized one.

Please let me know if that makes sense.

Thanks,

Christos

[v-tianyich-msft · Accepted solution]

Hi @CK1992 ,

I made some attempts and got two results. But the summarized one always gets the current visual data, the underlying one gets more fields. I guess your data model needs to be refined or your current visual is already all your relevant data.

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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