Salesforce Objects timing out almost every time now

Hi all -

The real culprit here is the time of response from Salesforce. This is not a proper solution but a symptom of it that will work as a bandaid solution. Below is how you can edit your heavy object queries from powerquery using M code.

For your query that is timing out -

• Open the Advanced Editor in power query
• In the Source step, add time out duration: After salesforce link ,[ApiVersion=48, Timeout=#duration(0, 0, 120, 0)]),
• This will override the default source response limit from 10 mins to 120 mins which is max allowed.
• This alone won't resolve the issue, make sure that your next query steps are basic such as removed other columns. Any heavy transformations on rows or data types will fail the load. I personally only have the source, navigation and removed other columns steps.
• Add timeouts for all the big objects that are failing the scheduled refreshes. Even though the total time limit allowed for all queries together on a PRO capacity is 120 mins, it will help all the queries that are taking time to load.

Thank you.

Kind Regards,

Shlok