cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tetyana_bilous
Regular Visitor

Experiencing Time Out error: “The operation has timed out” - connection to Salesforce objects

Hi guys, I have been exploring Power BI on my own for the last 6 month and was able solve many obstacles but not this one. Maybe you can help me or at least guide me into right direction.

I was able to connect Salesforce and load large data sets from there (13 mln rows, 4 columns of different data types, all unnecessary data was excluded). My profile is Pro, workspace is Premium.

But in Power BI service my report has been experiencing Time Out error: “The operation has timed out”. Though I was able to successfully refresh it for a few times, there was no successful refreshes recently.

 

Message that I get:

 

An error occurred while processing the data in the dataset.

Refresh failed:

Distrubution in PeTra - test online has failed to refresh.

Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

DataSource.Error: <pii>The operation has timed out</pii>. <pii>https://petra.my.salesforce.com/services/data/v48.0/query?q=SELECT%20ivybase__Available__c%2Civybase...</pii>. ;The operation has timed out. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: Appended Stock tracking.

Learn more >

tetyana_bilous_0-1643196408158.png

 

3 REPLIES 3
moldepc
New Member

@lbendlin 

I am having the same issue, but mine is timing out after only 5 minutes.  I created the dataflow to pull in a Salesforce object.  It was refreshing but then it stopped.  I tried hitting refresh today, but it failed again.  When I opened the dataflow & then resaved it, it refreshed.  Any ideas?

Error: Data Source Error : DataSource.Error: The operation has timed out

moldepc_0-1650899065993.png

 

Talk to your SFDC admins, tell them to stop messing with the session parameters.

lbendlin
Super User
Super User

It's not that the data refresh has timed out, your SFDC session token has expired before the refresh could be completed.

 

Power BI Service has a 600 minute timeout for scheduled refreshes.  Ask your SFDC admin if they can extend the session token lifetime to match this.

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Solution Authors
Top Kudoed Authors