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)...
Need Help
  • Anonymous's avatar
    Anonymous
    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.

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.