Change the Time-out Value for Data Mining Queries
Applies To: SQL Server 2016
When you build a lift chart or execute a prediction query, sometimes it can take a long time to generate all the data required for the prediction. To prevent the query from timing out, you can change the value that controls how long the Analysis Services server waits to complete a query.
The default value is 15; however, if your models are complex or the data source is large, this might not be enough. If necessary, you can increase the value significantly, to enable enough time for processing. For example, if you set Query Timeout to 600, the query could continue to run for up to 10 minutes.
For more information about prediction queries, see Data Mining Query Tasks and How-tos.
In SQL Server Data Tools (SSDT), from the Tools menu, selection Options.
In the Options pane, expand Business Intelligence Designers.
Click the Query Timeout text box, and type a value for the number of seconds.