topic Error while scheduling refresh for reports on Power BI report server in Report Server

Error while scheduling refresh for reports on Power BI report server

Moosa-Ali — Tue, 15 Feb 2022 10:39:50 GMT

While trying to schedule a refresh for any report on my report server, the following error is returned (Screenshot attached).
All data source verifications are sucessfull and the report is manually refreshed without errors. The older schedules are working perfectly but I am unable to schedule a new one. Please help

Re: Error while scheduling refresh for reports on Power BI report server

gharstev — Tue, 15 Feb 2022 20:52:58 GMT

hi - we're having the same issue today - started on last release (Sept 2021) and after upgrading to current (Jan 2022). Petebro any ideas?

Re: Error while scheduling refresh for reports on Power BI report server

Petebro — Tue, 15 Feb 2022 23:41:50 GMT

Can you provide a little more details. What types of data sources are being used in the reports for example?

Re: Error while scheduling refresh for reports on Power BI report server

Moosa-Ali — Wed, 16 Feb 2022 10:00:16 GMT

Our data source is MSSQL Server on-premises. Data is loaded from this SQL server into Power BI.
I beileve it would be helpful to mention here that we are using the free version of Power BI, could that be an issue?

Re: Error while scheduling refresh for reports on Power BI report server

v-luwang-msft — Fri, 18 Feb 2022 05:46:08 GMT

Hi Moosa-Ali ,

From the error message, we can know the issue is caused by the connection to report server database. In your scenario, I would suggest you check detail error information in Reporting Services error log (default location: %programfiles%\Microsoft SQL Server\<SQL Server Instance>\Reporting Services\LogFiles) around the time that the error message thrown out.

If you see the error "System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding" in log files, the issue is that the connection to report server database is timeout. Then you can follow Jin's suggestion to fix the issue: ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An e...

An you alos could try the following solution:

The fix is to grant sysadmin Privilege to Report server service account .

refer:https://social.technet.microsoft.com/Forums/ie/en-US/8decb9e2-ce0f-4f5a-a6ab-4ed2a7fe21e0/an-error-occurred-within-the-report-server-database-this-may-be-due-to-a-connection-failure?forum=sqlreportingservices

Similar question refer:(final it was actually an authorization issue, the virtual account lacked some sort of permissions so user changed to a domain account and now it works fine)

https://community.powerbi.com/t5/Desktop/An-error-occurred-within-the-report-server-database-SSRS-PowerBI/td-p/52811

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

Best Regards

Lucien

Re: Error while scheduling refresh for reports on Power BI report server

v-luwang-msft — Wed, 02 Mar 2022 02:46:29 GMT

Hi Moosa-Ali ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien