why the Export Data has different results than Export Formatted

Summary:

why the Export Data has different results than Export Formatted

Content (please ensure you mask any confidential information):

We are actually trying to export dashboard report out put . When we click on Export option we have two options which are Formatted and Data so here when i choose Formatted and select excel out put will get download in Excel format and in same way when i choose Data option and select excel out put will get download in Excel format.

But we could see data discrepancy in Out put as i am downloading same report at same time it should be same out put but we observed lot of difference like structure of out put , missed couple of fields when i select Export → Data → Excel option.