Troubleshooting Salesforce Reports

Troubleshooting "Too much data inside of one hour" limitation

Redisa Shehaj avatar
Written by Redisa Shehaj
Updated over a week ago

The Salesforce Reports API comes with certain limitations. One of which is that a report can only have 100 columns, groupings included. A work around to this if you need more than 100 is to split the report in two or more, for example.
Another one is that you can only retrieve 2000 rows of data per timestamp. The timestamp here being the date you selected to attribute your data to when you connected the source.

In order to get around this timestamp limitation we suggest:

  • Pick another date when connecting that always exists and is more evenly distributed.

  • Filter/group the data in the report in your Salesforce UI before connecting it to Funnel to only include the data you need.

  • Try out the standard Salesforce connectors to see if they can help. The downside of this solution would be that you would need to then join the data in your destination (where you are planning on exporting the data to).

  • If none of the above seem to solve this, please contact support.

Did this answer your question?