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 ...
Need Help
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