Error while scheduling refresh for reports on Power BI report server

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