cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rodeliosantos Frequent Visitor
Frequent Visitor

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

 

 

 

 

2 REPLIES 2
Moderator v-sihou-msft
Moderator

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

@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,

pablobarra Regular Visitor
Regular Visitor

Re: 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"

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 114 members 1,542 guests
Please welcome our newest community members: