Forum Discussion

fernandohiltner's avatar
fernandohiltner
Frequent Visitor
6 years ago
Solved

How to Bypass Salesforce 2000 Rows Limitation

Hey guys,   A few weeks ago I had a problem with the 2000 rows limitation while importing data from Salesforce to Power BI. I did a little research and found out that this was a problem with the Sa...
Tips and Tricks
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Fernando,

 

fernandohiltner 

 

Thanks for the solution here, is was fantastic.

 

But unfortunately I still have an issue to solve, when I am using google sheets and as my report is quite long, the Salesforce connector shows un error "Exceeded maximum execution time", and because of that I can't import the report. I have searched about this error and everyone says the limits is 5 min running, but I don't have a solution for that. Could you please help me on it?

 

Thanks,

MatheusFF

fernandohiltner's avatar
fernandohiltner
Frequent Visitor
6 years ago

Hi Matheus!

 

Anonymous 

 

Firstly, thank you for your feedback.

 

Regarding your problem, I have never faced this issue before. I guess this must be a limitation within Google Sheets for running scripts. I guess I would split the report into smaller parts (to run the request in less than 5 minutes) and then aggregate it all inside Power BI. Is this a viable option for you?

 

Hope it helps!