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.

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

May be you should contact the IT guy to help you find where the PowerBI RS database located.

Once you have the rights to access the database, your can find the tables via tools e.g. SQL Server Management Studio.

M_nwadibia's avatar
M_nwadibia
Icon for Resolver III rankResolver III
3 years ago

Thank You,

I resolved this problem for some of the reports by simply deleting the reports and uploading them again