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:

     

v-diye-msft's avatar
v-diye-msft
Community Support
6 years ago

Hi Andvil 

 

What kind of export are doing? Power Bi will let you export in two different ways:

  • Summarized data

  • Underlying data

Maybe you are not going through the option with your objective. You can check the difference here:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#export-data-fro...

Please check the following things:

1) If there are any filters.

2) If they are summarized data.

3) If the records exceed the limits. 30000 rows for .csv and 150000 for .xlsx file.

4) And more limitations, please refer to: limitations-and-considerations.

 

  • Andvil's avatar
    Andvil
    Helper V
    6 years ago

    Hi v-diye-msft,

     

    I was able to solve the problem. I was exporting from PBI DESKTOP as summarized data in csv to excel, it is under the 30000 rows limit, and had the totals differences error. I tried exporting from PBI SERVICES to excel as summarized data in .xlsx file and finally I got the same numbers.

     

    1) Why when exporting from PBI services it works but when exporting the same file from PBI Desktop I have differences? Is there a bug in desktop export?

     

    2) The option of "underlying data" is disabled, even though I am the owner of the report and I activated the option "allow final users to export summarized data and underlying data", it says that I do not have permission to export underlying data.

     

    Thank you for teh help,

     

    Best,

    JALV

    • v-diye-msft's avatar
      v-diye-msft
      Community Support
      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

        Thank you v-diye-msft, I am going to check with the option you highighted and see if I still have differences importing from desktop to excel. I solved the exporting problem by publishing to PBI services and then exporting, but I still have to check exporting differences from desktop.

         

        Thank you for the help,

        JALV