Forum Discussion
Solved
Analyze in Excel Error: MaxPacketLimitReached
I am analyzing a report in Analyze in Excel and there is one numeric field that triggers the error copied below. Other fields are pulled into the pivot table without issues. We couldn't get data ...
Thanks GilbertQ for your input! This isn't the direct solution to the issue, but I switched to Import mode (from Direct Query) and the error is gone. This does appear to be a row limit issue, specifically in direct query mode.
I also have the same issue, Did you ever have any luck with this?
I can't remember TBH, it was such a long time ago. But after this initial testing with Report Builder, we determined it was too horrible an experience to use in production and so we switched to InfoRiver Matrix. It was like going from hell to heaven, I kid you not--Report Builder user experience is that bad.