No, it is a unusual behavior. When we refresh data successfully, the data in the PowerPivot window is replaced with new data. In your case, please check the data refresh history. Data refresh history is a record of all data refresh activity for PowerPivot
data in an Excel workbook. For more information, please see: http://technet.microsoft.com/en-us/library/ee210622.aspx
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.