Forum Discussion

FelipeNer0's avatar
FelipeNer0
New Member
1 year ago
Solved

Report Server does not update with scheduled plan

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."

  • Anonymous's avatar
    Anonymous
    1 year ago

    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-power-bi-report-server-v-5-x-
    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.