I need some help to find out what's ausing this issue. I am uploading some records from our Salesforce.com instance to PowerBI.
I am uploading the whole Contact object which involves 4 million data rows but i a always getting this error: "OLE DB or ODBC error: [DataSource.Error] The operation has timed out" and sometimes hetting this error also: "There's not enough memory to complete this operation. Please try again later when there may be more memory available".
It seems there're too many rows through an API call. I suggest you separate this query into multiple datasets. I'm not familiar with SalesForce API, if it doesn't support apply parameter/argument to control timeout or limit imported rows, I recommend you import those data into an on-premise database. See: Easy and Flexible Salesforce Reporting with Microsoft Power BI