Forum Discussion
Power Bi to Excel exporting error
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:
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
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:
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