Export File Shows Different Total of Column?

[pescem2]

My PBI table is showing one total, but when I export the summarized data, it shows a different total. Any ideas as to why?

[pescem2]

I have a theory that I am hoping someone can confirm...

I believe the totals didn't match up because the dataset was in the middle of a refresh. It is my opinion that either the report was showing a previous total and the refresh caused the export to have a mish-mash of "old" and "new" data caused by the refresh.

Thoughts?

[ibarrau]

That is a good theory. Can you try again without refreshing while exporting?

[pescem2]

Sorry I forgot to mention that I did an export while the dataset wasn't refreshing and my totals matched.

[v-lid-msft]

Hi @pescem2 ,

It seems like a possible reason, Does the issue happen every time when the dataset is refreshing? Could you please try to reproduce this issue again when the dataset is refreshing?

Best regards,

[pescem2]

Yes, I exported again during a refresh and my totals were different. I am going to assume this was the cause of the issue the entire time.

[v-lid-msft]

Hi @pescem2 ,

Does there have extra rows / records in table visual after exported, Or just the value of total changed? What is the connective mode of this report, Import , DirectQuery or Live Connection? Does there any Row-Level Security (RLS) applied to this report?

Please don't contain any Confidential Information or Real data in your reply.

Best regards,

[ibarrau]

Hi, please pay attention at the way you are checking the options of the export. You can export summarized or underlying data like the picture:

Export options

Regards,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[pescem2]

We block exporting underlying data as a company policy, but that still doesn't explain why the summarized data doesn't match my table.