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

Error when executing a scheduled refresh.

Hi PBI RS Community,

 

Since last Friday, we've been getting this error for our scheduled data refreshes. 

 

User are having to open the report in PBI Desktop, refresh and save back to RS. 

 

I've been looking through the log files but couldn't find any useful info or clues to why this could be happening.

 

I am contemplating a server reboot hoping that it would fix the issue. However, before I do that, i'd like to know what the root cause is and a possible fix is so that if this happens in the future, i'll know what to do. 

 

SessionID: 5329586f-5338-4465-b285-760658dd2a0b
[0] -1055784932: Timeout expired. The timeout period elapsed prior to completion of the operation.. The exception was raised by the IDbCommand interface.
[1] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[2] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[3] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[4] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[5] -1055784932: Timeout expired. The timeout period elapsed prior to completion of the operation.. The exception was raised by the IDbCommand interface.

There have been no changes to the reports, dashboards and credentials. Data source connection test is successful. 

 

Any help is would be greatlty appreciated.

 

Thanks in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Frequent Visitor

Re: Error when executing a scheduled refresh.

Hi, 

 

We fixed the issue by restarting the Report Server service. There was no unexpained growth in data volumes. Infact, data volumes were small only a few hundreds of rows.

 

Thanks, PowerAI.

View solution in original post

2 REPLIES 2
Highlighted
Impactful Individual
Impactful Individual

Re: Error when executing a scheduled refresh.

Have you tried running the various queries or attaching some kind of profiler to the source of the data? Is it suddenly performing really badly? (data growth can cause these kinds of issues)

Highlighted
Frequent Visitor

Re: Error when executing a scheduled refresh.

Hi, 

 

We fixed the issue by restarting the Report Server service. There was no unexpained growth in data volumes. Infact, data volumes were small only a few hundreds of rows.

 

Thanks, PowerAI.

View solution in original post

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Kudoed Authors