Forum Discussion
Extremely Slow Connection to Salesforce since update
PowerQuery Desktop...
I am totally struggling with a repeating problem.
This is a merged query to custom objects.
Top level query is to an Excel Table listing two (2) quote numbers.
The first merge is matching (left outer) to custom SFDC object "Oracle Quote" which returns two records.
Matching Quote number in first to Quote Number in second.
Still in the top level query, a second merge is to the "Quote Products", which according to my information should return some 80 matching records.
Matching quote Record ID in first (the id retrieved in the first merge query) with the Quote Id field in seconf (left outer).
Once in a blue moon this appears to run normally and completes in say a minute.
Most the time the query times out.
All the records are showing in the Editor.
It seems to be the refresh from Excel that is always a problem.
Extremely frustrating as we try to re-build our sales operations processes on top of Power Query (transitioning from lightwight, but likely to disappear one day ExcelConnector)
This error seems to have reappeared in the December 2017 Update. Can anyone else confirm if they are getting this error again?
Keith_HAdvocate I
Hi Thomas
I've just built my first report using a Salesforce source and could probably enter the data manually quicker than PBI refreshes it.
