Forum Discussion

Dearc's avatar
Dearc
Icon for Helper II rankHelper II
4 years ago
Solved

Scheduled refresh stuck or delay

Hello PBRS team,   I'm using the version 1.14.8179.37378 (2022, May). Two server grouped as scale-out.   Recently I found that scheduled refresh delayed and stuck when mannlly triggeredand then s...
Schedule refresh not working
  • Dearc's avatar
    Dearc
    4 years ago

    I think I found the root cause.

     

    Some reports set refresh plan each mintune that makes so many tasks are queued and make [dbo].[Event] full. 

     

    Once I rescheduled these planns and delete all from the [dbo].[Event] table, schduled refresh plan work again and on time finished.

v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
4 years ago

Hi Dearc ,

 

Are you viewing a refresh-related log file that doesn't show specific refresh information?

 

Also, you can read below troubeshooting for more details.

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


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


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

Dearc's avatar
Dearc
Icon for Helper II rankHelper II
4 years ago

Yes I checked logs. Nothing specical found only the strange refresh timing

 

I set 3 scheduled refresh plan, 2 of them refresh daily in 7am and 8:20am. And the other refresh each hour. 

 

 

 

 

Logs show as  below, none of them exectued in right timing.

 

 

 

There're 6900+ records in  [PowerBiReportServer].[dbo].[Event] table and still growing. I' m not sure if this related with the problem.