Forum Discussion
OLE DB or ODBC error: [DataSource.Error] The operation has timed out
Hello! 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 mi...
v-sihou-msft
Microsoft Employee
Microsoft Employee
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
Regards,