Forum Discussion
PowerBi report refresh timing out
Community SupportHi sydneycroud ,
If your query needs more than the default 30 seconds, you might want to set the commend timeout higher:
And please also refer to https://blog.sqlauthority.com/2016/01/26/sql-server-timeout-expired-the-timeout-period-elapsed-prior-to-completion-of-the-operation-or-the-server-is-not-responding/
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Thank you for your suggestion, Demon.
However, I had adjusted that setting to 30 minutes, even though the query typically finishes in less than two minutes. It had no impact and the refresh continues to fail.
As I mentioned, when monitoring the refresh, I see the queries run and they complete processing. It appears the timeout is occurring when it is saving the results of the queries back to the model, which I assume means updating the actual report.
Olá, eu estou com o seu mesmo problema, encontrando o mesmo erro que você mostrou nos logs, é incrivel, pois isso começou do absoluto nada na versao de may de 2024. você solucionou isso? é incrivel como tentei absurdamente achar uma solução para isso, tantos nos forums, nos logs, no banco do report server, nas configurações, no sql agent, mas nada funciona por enquanto. espero que você tenha encontrado alguma solução.
