topic Re: Scheduled Report Refresh Error in Report Server

Scheduled Report Refresh Error

Anonymous — Thu, 09 Sep 2021 06:12:20 GMT

Hello Experts-

I have around 40+ reports on Power BI Report Server.

They are in import mode and pointed to SAP HANA Database.

All are scheduled to refresh in 15 mins.

In many of the reports I am getting error as "The connection either timed out or was lost"

Request you to please help.

Thanks!

Re: Scheduled Report Refresh Error

d_gosbell — Thu, 09 Sep 2021 06:49:43 GMT

I suggest you contact the admin of the HANA system. It sounds like the issue might be at that end. If you have 40+ reports refreshing every 15mins you might be hitting some sort of connection limit.

Re: Scheduled Report Refresh Error

v-henryk-mstf — Mon, 13 Sep 2021 07:19:06 GMT

Hi @Anonymous ,

According to your description, it may be caused by the excessive number of refreshed reports and excessive memory pressure. For more details:Troubleshoot scheduled refresh in Power BI Report Server - Power BI | Microsoft Docs

Or check whether the credential information of the data source is invalid, which can also cause such problems.

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Scheduled Report Refresh Error

Anonymous — Fri, 24 Sep 2021 06:39:28 GMT

Hello @v-henryk-mstf - Thanks for you reply.

I have checked memory of server. It has 64 GB RAM and average usage is around 70%.

Credentials are correct as we are facing this issue in some of the reports not in all. Some are getting successfully refreshed.

Please let me know how I can get detailed error information.

As attached in screenshot that is the only information present in the error.

Looking forward for your reply.

Thanks in Advance!