Forum Discussion

haraldjw's avatar
haraldjw
Frequent Visitor
4 years ago
Solved

Export to Excel with summarized data still shows underlying data

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?

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      haraldjw
      Frequent Visitor
      4 years ago

      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.