Change the Time-out Value for Data Mining Queries

Applies to: SQL Server 2019 and earlier Analysis Services Azure Analysis Services Fabric/Power BI Premium

Important

Data mining was deprecated in SQL Server 2017 Analysis Services and now discontinued in SQL Server 2022 Analysis Services. Documentation is not updated for deprecated and discontinued features. To learn more, see Analysis Services backward compatibility.

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 SQL Server 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.

Configure the time-out value for data mining queries

  1. In SQL Server Data Tools, from the Tools menu, selection Options.

  2. In the Options pane, expand Business Intelligence Designers.

  3. Click the Query Timeout text box, and type a value for the number of seconds.

See Also

Data Mining Query Tasks and How-tos
Data Mining Queries