OLE DB or ODBC error: [DataSource.Error] The operation has timed out

[rodeliosantos]

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 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".

Thanks in advance!

Del Santos

[ReportRanger]

Hi @rodeliosantos were you able to find a solution? As a workaround, maybe you can try to test your connection with a 3rd party connector. I've tried windsor.ai, supermetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the Salesforce connector in the data sources list:

After that, just grant access to your Salesforce account using your credentials, then on preview and destination page you will see a preview of your Salesforce fields:

There just select the fields you need. It is also compatible with custom fields and custom objects, so you'll be able to export them through windsor.  Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url. 

[pablobarra]

Hi

This may be caused because of calculated fields (Froumula or Roll up summary fields in Salsforce).

You can apply a step at the early beggining of the transformation,  "Remove other columns" and leave only the ones you need (all except the formulas you do not need).

For example, the error may be caused by a single Roll up summary that is looping over opportunities.

The step to remove columns should be applied before any transformation is made to the columns.

Your code will look like this:

let
Source = Salesforce.Data(),
Account = Source{[Name="Account"]}[Data],
#"Removed Other Columns" = Table.SelectColumns(Account,{"Id", "Name"})
in
#"Removed Other Columns"

[v-sihou-msft]

@rodeliosantos

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,