Forum Discussion

Andvil's avatar
Andvil
Helper V
6 years ago
Solved

Power Bi to Excel exporting error

Hello to everyone,   I am having an error when exporting a pivot table from Power Bi to Excel. The totals do not match and I have missing information. I am attaching a PDF where it shows the differ...
Need Help
Show and Tell
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi Andvil 

    1) Select the option for Summarized data if you want to export data for what you see in that visual. This type of export shows you only the data (columns and measures) that are being used to create the visual. If the visual has an aggregate, you'll export aggregated data. For example, if you have a bar chart showing four bars, you'll get four rows of Excel data

    For help understanding aggregates, see Aggregates in Power BI.

     

    Meanwhile, I tested it on my side and they're same output in both desktop and service. Make sure there're no filters applied.  

     

    2) Make sure the option is enabled in the desktop:

     

amitchandak's avatar
amitchandak
Super User
6 years ago

Andvil , if you are using measures, please share their calculations. In power BI measure's grand total is calculated, so in case row context is not correct grand total may differ