Salesforce query 2000 row limit

gvillepa

New Member
Joined
Oct 18, 2017
Messages
31
Anybody know of a workaround with the salesforce report query source 2000 row limit? I can't use the salesforce objects because I don't have developer access permissions and the current objects and field relationships don't mesh well, no record id to merge object queries.
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,516
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
what is your available query
 

gvillepa

New Member
Joined
Oct 18, 2017
Messages
31
So I have a salesforce report that gives me exactly what I need. I can query the report in excel and it works perfectly, with the exception that it is limited to 2000 rows.

The salesforce objects connection in excel power query requires 2 objects, accounts and calls. The problem is i cant merge accounts and calls because there is no identifier to match for calls and accounts. If I had developer permissions I'd create a record id for each object to connect them.

So my question remains, is there a way to pull from the salesforce report query connection and pull all 40000 rows of data I need. It's limited to 2000.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,939
Messages
5,525,741
Members
409,661
Latest member
pprabha

This Week's Hot Topics

Top