Are there differences between the Reports API in Lightning and Classic?

When one of our users using Classic pulls a Saved Report we get all the rows. When they are using Lightning and pull a Saved Report we only get 2k rows.

  • other user has the same permissions as you, or same profile / role ? And I wouldn't fetch that many at once, and try using LIMIT in query
    – Mac A.
    Commented Sep 20, 2018 at 0:01
  • @MacA. same user I toggle it back and forth. We are trying to load in the whole saved report, what kinds of limit queries would you use to paginate it? Commented Sep 20, 2018 at 22:39
  • Did Salesforce just push this problem to all saved reports? Classic and Lightning? Everything broke for us today. Commented Mar 20, 2020 at 21:45

1 Answer 1


It's a salesforce limitation, Refer here

The API returns up to the first 2,000 report rows.

  • Thanks. From the link it says 'Available in: Salesforce Classic (not available in all orgs) and Lightning Experience' but the experience is different in lightning and classic? Commented Sep 20, 2018 at 22:38

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .