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.
Hi there
From the message it would indicate that the amount of rows that it will request is more than the default (which from my understanding is 1 million rows)
If you could confirm if you run a query on the SQL database for that column how many rows it returns?
From the message it would indicate that the amount of rows that it will request is more than the default (which from my understanding is 1 million rows)
If you could confirm if you run a query on the SQL database for that column how many rows it returns?
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.