Anonymous's avatar
Anonymous
Not applicable
7 years ago
Status:
Accepted

Export full query to Excel/CSV

Hi,   In Power BI Service when I export the summarized data from a visualization to .xlsx (excel) and .csv format, and in excel I apply a pivot table to that data, I find different values.   When...
Reports
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi, 

 

I forgot to mention an important detail. The values in my dataset has decimal places, but I formated the column to 0 decimal places.

 

So in power BI I have this table:

 

When I export to .CSV:

 

When I export to .xlsx (excel):

 

The total on the .csv is 25 and in excel is 26 (25.61), like Power BI.

 

I am using dummy data, but in my real case with a larger dataset the difference is much more significant.

 

I'm waiting for feedback

 

Thanks!

Completed Ideas