Auto-refresh fails occasionally

[MathiasMoen]

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 refresh fails for a report, and sometimes it does not. The manual refresh always works.

The error message points to one of the tables that is imported into the report. I am not doing anything with this table, besides connecting it to other tables. I make other tables based on this table.

When importing multiple tables, is the sequence of tables important (when checking the Transform data tab) when relations between them is set up? Or are there other factors that may cause this problem? 

[MathiasMoen]

Thanks for the answer.

I will do a check on the reports, and use your points as a guidance!

[Akash_Varuna · Accepted solution]

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