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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Salesforce query 2000 row limit
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.
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.
Upvote
0
Similar threads
- Question
