Forum Discussion

honza1118's avatar
honza1118
Frequent Visitor
6 years ago
Solved

timeout information needed

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 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      honza1118
      Frequent Visitor
      6 years ago

      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