Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Export data to .csv and excel

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 I choose the .csv format I loose data precision, decimal places are lost, and when I apply a sum to a sample of data the total is different then the total in the power bi, because the data are rounded and only after this the sum is applied.

 

When a choose the .xlsx (excel) format I don't lost the decimal places and the total (sum of all values) is the same as power bi.

 

So it seems that the export to .csv format its not trustly.

 

Could you help?

 

Thanks in advanced

Status: Needs Info
Comments
v-yuezhe-msft
Employee

@acosantos,

I am unable to reproduce this issue using my sample data. Please check my screenshots below. And you can test my PBIX file on your side.
Export to excelExport to excelExport to csvExport to csv

If the issue still persists, you can share me a PBIX file containing dummy data so that I can reproduce.

Regards,
Lydia

v-yuezhe-msft
Employee
Status changed to: Needs Info