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:

     

Andvil's avatar
Andvil
Helper V
6 years ago

Hi amitchandak 

I have not used any measure. It should just sum the number of kilos or shipments I have, as predetermined in the table visual. I'm not using any special calculations or measures, that's why I cannot figure out why I have the differences when exporting.

 

Best,

Jalv