Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.