it seems that the issue is that the SSRS report generates multiple worksheets. I haven't found out why but it seems as though there is a data limit per worksheet.