Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
patricky15
Frequent Visitor

Weird Errors with Refresh

Within Power Bi Desktop, I have a dataset that connects to Google Sheets(~40k rows), Salesforce, and Smartsheets. There is a total of 22 queries in this dataset. I publish this dataset and report to Power BI service so non Desktop users can view and ultimately refresh the data. When we refresh within the service, we are running into odd errors that really do not give much information:

DataSource.Error: <ccon>The operation has timed out. (google sheets link) </ccon>;The operation has timed out. The exception was raised by the IDbCommand interface. Table: Unique Projects for SS Joins.

This error occurs sometimes and other times the refresh works successfuly without any change to the dataset whatsoever. We ultimately want any user to refresh the data but this will not work when the owner of the data set is getting these unkown errors.

1 REPLY 1
GilbertQ
Super User
Super User

Hi @patricky15 

 

I have seen this sometimes happen when there are connectivity issues.

 

To resolve this what I have done in the past is to use my On-Premise Gateway to connect to the data sources. The reason I do this is because I can monitor and control the connectivity to the data.

 

To do this make sure you have the following setting enabled in the gateway.

GilbertQ_0-1659909193277.png

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors