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

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"