Report Server does not update with scheduled plan

[FelipeNer0]

I am facing an issue with the scheduled update on my report server. I configure the data source settings, and everything is fine. I create the scheduled update plan, but it only works when I click "Update Now." It does not follow the created schedule and does not update automatically—I have to keep clicking "Update Now."

[v-jtian-msft · Accepted solution]

Hi,d_gosbell and ChrisMuthmann ,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.
Hello,@FelipeNer0 .I am glad to help you.

I think it is possible that the power BI Report Server is offline causing the configured schedule refresh not to execute
The report server acts as a local server and scheduled refresh depends on the normal operation of the server and related services, so when the computer is offline or the server is shut down, scheduled refresh will not be executed.

Please try to check the following operation:
The following is what I did to configure the schedule refresh in import connection mode in Report Server
URL:
support.biconnector.com/support/solutions/articles/8000085540-how-to-configure-scheduled-refresh-in-...
1.Check your data source credentials configuration

2. Configure a refresh schedule

3. Ensure that SQL Server's Service Agent is running properly (is turned on)
Scheduled Refresh in SQL Server relies on the Service Agent.

Most importantly, make sure your server is always online (the computer acting as the server is not turned off)

You can see that my last refresh was in September 2024, which is a very long time ago, but the configuration is correct and manually executing a refresh now performs fine. The reason for this is that the report server is a local server and scheduled refreshes are dependent on the server and related services running properly, so when the computer is turned off or the server is shut down, scheduled refreshes will not be executed.
You need to make sure that your computer is not shut down (the report server and the service agent are online).

You mentioned that you clicked refresh now and it worked, which means that the overall configuration information is correct. Ensuring that the server is always online is a key factor in ensuring that the scheduled refreshes set up in the server can be performed automatically.
Correspondingly, for the Power BI Service in the cloud, there is also a requirement that the gateway is online.
Solved: Schedule Data Refresh when Computer is Shut Off? - Microsoft Fabric Community

For more detailed information on viewing the refresh log for more details, I hope the link below is helpful:

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

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[d_gosbell]

You need to check your data source in this list to see if it supports scheduled refresh
Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn

[ChrisMuthmann]

Have a look at the job in SQL Server Agent. If the scheduling there is not correct, delete the scheduled update and try it again. Alternatively, drop the job and restart the sql server (which maybe isn't possible).

You can find the job for your report via this sql:

use ReportServerDB
go

select c.path,
upper( s.scheduleid) as sqlagent_job_name
from         
  [catalog] c
inner join ReportSchedule rs on   rs.reportid = c.itemid
inner join Schedule s on   rs.scheduleid = s.scheduleid ;