Forum Discussion
Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the oper
Hi , We have an azure sql database and using virtual neywork data gateway to refresh reports via the service and these work o.k. However, one report seeing an issue with is incremnetal refres...
Thanks for replies.
It is an azure sql database - on the clinet ssms it is 0 so runs permanently.
However, in power bi an incrementallly refreshed report timing out after 80 minutes.
Other reports we see tiemout afetr 5 hours in premium workspace thus don't understnad wheer ethe 80 minutes comes from - report itself has no timeout set so woudl have thought woudl eithre run for 10 minutes and timeout or 5 hours and timeout.
Given other reports and sqls can run over 10 minutes seems not to be a database timeout and just wondering if some setting somwhere for incremental refresh gest set to 80 minutes?
Howeverm in power bi
Did you consider my suggestion to modify the command timeout setting?