none
Microsoft Sql server data-mining add-on for excel 2013:

    Question

  • In browsing the models using excel data-mining add-on the browsing query recognized that the query times out after 60 seconds. The question is how we can increase the query time-out time for data-mining add-on?

    Sunday, July 28, 2013 7:11 AM

All replies

  • Perhaps you are meaning the timeout settings for your Analysis Server -- under Properties, General, DatabaseConnectionPoolConnectTimeout defaults to 60.   Though I doubt that browsing any model should take 60 seconds.  Try browsing the model from Management Studio and seeing if you also need a lot of time.


    Mark Tabladillo PhD (MVP, SAS Expert; MCT, MCITP, MCAD .NET) http://www.marktab.net

    Tuesday, April 22, 2014 11:39 PM