Forum Discussion
Power Query Salesforce Refresh
Hi I have a query that readily pulls data from Salesforce Task object directly into Excel 2010 via Power Query. I need to schedule this to run after midnight and retrieve a previous day's dat...
I suggest you add timeout in your underlying M query. Go to Advanced Editor, and "[Timeout=#duration(0, 0, 30, 0)]" in your query string. Please refer to links below:
https://community.powerbi.com/t5/Desktop/Query-Timeout-on-update/td-p/53459
Regards,
Thanks for the suggestion, unfortunately this doesn't appear to work with Salesforce objects:
Just for clarity, my query isn't timing out due to the time taken to pull back data from Salesforce (that works quickly) - it's the refresh that causes the issue. Not sure whether this timeout statement would resolve that?
Did you resolve this - I have exactly the same issue