Forum Discussion
Solved
Auto-refresh fails occasionally
Hello, I have set up a couple of reports that is connected to an on-premise sql server through a gateway. The reports updates around 6 times a day. The problem is that sometimes the auto refr...
Hi MathiasMoen It might be beacuse of number of the reasons like
- Gateway or network issues; ensure the gateway is updated and stable.
- SQL Server timeouts; optimize queries and use query folding.
- Concurrency; stagger refresh schedules to avoid overlaps.
- Data model; check for complex or circular relationships.
- Large data or transformations; simplify transformations or use incremental refresh.
I dont think it is caused by the sequence of importing tables
Hi MathiasMoen It might be beacuse of number of the reasons like
- Gateway or network issues; ensure the gateway is updated and stable.
- SQL Server timeouts; optimize queries and use query folding.
- Concurrency; stagger refresh schedules to avoid overlaps.
- Data model; check for complex or circular relationships.
- Large data or transformations; simplify transformations or use incremental refresh.
I dont think it is caused by the sequence of importing tables