timeout information needed

[honza1118]

Hello, 

I could not find information about timeout command. In Power BI desktop I set up timeout command for MSSQL server query for 2 minutes. When refreshed in Service (scheduled refresh) it is fine for most runs, but sometimes it fails on timeout. In refresh history I can see refresh start time and refresh end time and for fails it is alsway 1minute and 3sec. difference .... not 2 minutes. Also what is wierd is that some succesfull refreshes took longer time than those which failed. 

So my questions are 1) can we relly on refresh start and end time information which power BI tells us?

                                  2) when does timeout starts to countdown? Is there any kind of documentation about this? 

Thank you 

[Seth_C_Bauer]

@honza1118 I believe refresh timeout defaults are either 30 or 60 minutes... I wouldn't recommend over riding the timeout to such a small window.

[honza1118]

Hello, 

thank you for your answer. I could change the timeout from 2minutes to higher number, but i am not really sure why a refresh of few thousand rows shoud take more than 2 minutes. That is why I would like to know what is exactly happening during the resfresh. Is the timeout set up for whole refresh or only pulling the data from the MS SQL data source? Is there somewhere a documentation for the refresh where I could learn how does it work? 

I dont want the refresh to block my datasource for other processes running there. 

Thank you 

[Seth_C_Bauer · Accepted solution]

@honza1118 https://docs.microsoft.com/en-us/power-bi/refresh-data