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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.