Forum Discussion
Helper IIScheduled refresh stuck or delay
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.
Helper III 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.
Resolver IIIHello Dearc,
I am facing similar challenge. Can you provide me the steps you followed to achieve this?
- Dearc
Hi,
May be you can try1. Check the scheduled refresh plan for each report, make sure there're no plan set too frequently
2. Check is there any reports take too long for refresh especailly for some import huge data lines from SQL server or other data source
3. Check table [dbo].[Event], normally it is empty4. Check view [dbo].[ExecutionLog3] to see what happen while refresh for each report
Hope it works- M_nwadibia
Hello Dearc,
How do I locate files in step 3 and 4 ?
- Dearc
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.