Export to Excel with summarized data still shows underlying data

[haraldjw]

When exporting to Excel, in several dashboards and after choosing 'summarized data', all detailed data is shown.

I have experienced this since the last update. (Now: Serviceversion 13.0.16934.66)

What happened? or

What am I missing?

[v-rongtiep-msft · Accepted solution]

Hi @haraldjw ,

Please have a try.

Select File>>Option and Settings>>Options>>Current file>>Reprt settings>>Export data.

Select the option you need.

Please refer to the document for further information.

https://www.designmind.com/business-intelligence/export-underlying-data-in-power-bi/

Best Regards

Community Support Team _ polly

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

[haraldjw]

Hi v-polly-msft,

Thanks for you answer. It brought me to the solution.

I did choose for Summarized data, but now I realise that the table included a lot of detailed data, which is included in export. That is indeed without underlying data, because I included the underlying data in the table itself.

I suppose the solution is that I remove underlying data from the table.