Power Bi RS scheduler refresh error

Hi,  Anonymous 

"An error occurred within the report server database" is usually due to a database connectivity issue and PBIRS is unable to connect to or operate the underlying SQL Server database; The permissions are misconfigured, and the permissions of the service account or execution account are insufficient. SSL certificate configuration issues, not properly configured or bound after updating the certificate; Insufficient log or disk space, the operation fails due to insufficient database disk space; The service dependency is abnormal, and the SQL Server Agent or other dependent services are not running. You can check the following link:

Troubleshoot scheduled refresh in Power BI Report Server - Power BI | Microsoft Learn

You need to check the database connection and status to verify the database accessibility. Use SQL Server Management Studio (SSMS) to manually connect to the PBIRS report server database (the default name is ReportServer). Check that the database status is online and that it is not in read-only mode. Then check the disk space:
SQL statement

EXEC master.dbo.xp_fixeddrives

Make sure that there is enough space on the disk where the database resides (at least 20% remaining).

You will also need to verify the permission configuration and open the PBIRS Configuration Manager > Execution Account. Make sure that the account has the RSExecRole role in SQL Server permission. Write access to the ASEngine directory (approximate location C:Program FilesMicrosoft Power BI Report ServerPBIRSASEngine).
Service account permissions: The PBIRS service running account (NT ServiceReportServer by default) needs to have local administrator privileges and the sysadmin role in SQL Server.
Next, check the SSL certificate configuration. Open IIS Manager and check the HTTPS bindings for the PBIRS web portal and the report server site. Ensure that the certificate is correctly selected and has not expired, and that the binding port (default 443) is not conflicting. In the PBIRS Configuration Manager, > Web Service URL, and Web Portal URL, verify that HTTPS is configured correctly. Restart the PBIRS service for the configuration to take effect.

Or restart the related service, restarting (requires administrator privileges) SQL Server Agent, Power BI Report Server service, IIS in order (run the iisreset command). Then observe if the problem is solved.

You can also refer to the following post:

Solved: Power Bi report server was unable to create a sche... - Microsoft Fabric Community

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

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