Any limit on the number of report records/odbc connection to excel?

Mike L.
Mike L. ✭✭✭
edited 12/09/19 in Smartsheet Basics

Is there any limit on the number records that can be returned into a report?  If you don't mind sharing, what's the largest data set you have in a report?

What about a limit on report rows when using the data connector. I'm using the data connector to use the smartsheet report as a data source for a pivot table in excel.  This works fine for relatively small reports.  The larger the report data set the longer it takes the query to refresh (I guess this is to be expected).  Today I tried to use a report that contained >200K rows but the data connector said that the table did not exist.  I changed the report builder so that there were around 600 rows and it loaded the data without any problem. 16K rows loaded without issue, 33K rows loaded but when I tried to load 65K rows I received the error: There was an error executing an SQL query: "no such table".  

Thanks for your thoughts!  -Mike

 

 

Comments