Forum Discussion
Solved
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 a...
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
amitchandak
Super User
Super Useraswathyjoe , 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