Forum Discussion
PowerBI Export Data is different than the table visual
I am simply calculating the pay amount for each client and, on the grand total it shows 166461
But when I export the same data to excel, the total amount is different as shown below. Can anyone tell me whats going on in here?
aswathyjoe , Couple of reasons.
1. Power BI does export more than 30K in csv and 150K in excel.
2. Power bi recalculate the Grand total, so in case you are using row context, it would not be a simple sum of rows
Refer why Grand total is wrong -https://www.youtube.com/watch?v=ufHOOLdi_jk
1 Reply
- amitchandak
Super User
aswathyjoe , Couple of reasons.
1. Power BI does export more than 30K in csv and 150K in excel.
2. Power bi recalculate the Grand total, so in case you are using row context, it would not be a simple sum of rows
Refer why Grand total is wrong -https://www.youtube.com/watch?v=ufHOOLdi_jk