Forum Discussion
Salesforce data load stops at 128001
I try lo load the Account table and it stops at 128.001 with one error (I've seen there is another post with the same problem). If I refer to the same query, I can get different numbers: -- 128....
This happens ALL THE TIME at our organization. It's not pulling in all the rows from Salesforce.
The only work around we've been able to figure out, is to load the entire object into excel without filtering anything in powerquery (from what I understand, when you filter in powerquery, it bumps into salesforce's restrictions very fast). Then once it's loaded into a table, create a new query and link to the loaded table. Then perform your transformations in a second query locally.