Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
Drillthrough is the ability to query either a mining model or a mining structure and get detailed data that the model doesn't expose.
SQL Server 2017 provides two different options for drilling through into case data. You can drill through to the cases that you used to build the data, or you can drill through to the cases in the mining structure.
Drillthrough to model cases versus drillthrough to structure
Drilling through to model cases is useful for finding extra details about rules, patterns, or clusters in a model. For example, you don't use customer contact information for analysis in a clustering model, even if the data is available. By using drillthrough, you can access that information from the model.
In contrast, drillthrough to structure data provides access to information that the model doesn't make available. For example, the model might exclude some structure columns from a model because the data type is incompatible or the data isn't useful for analysis.
Enabling drillthrough on a model
To use drillthrough on a mining model, the following conditions must be met:
You can configure drillthrough on just the model cases and not on the mining structure, but not vice versa. To permit drillthrough to the mining structure, you must enable drillthrough on the mining model.
Drillthrough is disabled by default on both model and structure. If you use the Data Mining Wizard, the option to enable drillthrough to the model cases is on the final page of the wizard.
You can add the ability to drill through on an existing mining model, but you must reprocess the model before you can drill through to the data.
Drillthrough doesn't work unless the cache that the training process creates is preserved. For more information about the properties that control caching, see Drillthrough on Mining Structures.
Models that support drillthrough
If you configure a mining model to allow drillthrough and you have the appropriate permissions, you can select a node in the viewer when you browse the model. You can retrieve detailed information about the cases in that node.
Not all models support drillthrough. Support depends on the algorithm that you use to create the model. The following table lists the types of models that don't support drillthrough, or support drillthrough with limitations. Any model types not listed here support drillthrough.
| Algorithm name | Support for drillthrough |
|---|---|
| Microsoft Naïve Bayes algorithm | Not supported. These algorithms don't assign cases to specific nodes in the content. |
| Microsoft Neural Network algorithm | Not supported. These algorithms don't assign cases to specific nodes in the content. |
| Microsoft Logistic Regression algorithm | Not supported. These algorithms don't assign cases to specific nodes in the content. |
| Microsoft Linear Regression algorithm | Supported. Because the model creates a single All node, drillthrough returns all the training cases for the model. If the training set is large, loading the results may take a long time. |
| Microsoft Time Series algorithm | Supported. However, you can't drill through to structure or case data by using the Mining Model Viewer in Data Mining Designer. You must create a DMX query instead. Also, you cannot drill through to specific nodes, or write a DMX query to retrieve cases in specific nodes of a time series model. You can retrieve case data from either the model or the structure by using other criteria, such as date or attribute values. To view details of the ARTXP and ARIMA nodes created by the Microsoft Time Series algorithm, it might be easier to use the Microsoft Generic Content Tree Viewer (Data Mining). |
Related tasks
For more information about how to use drillthrough with mining models, see the following topics.
| Tasks | Links |
|---|---|
| Use drillthrough in the mining model viewers. | Use Drillthrough from the Model Viewers |
| Retrieve case data for a model by using drillthrough. | Drill Through to Case Data from a Mining Model |
| Enable drillthrough on an existing mining model. | Enable Drillthrough for a Mining Model |
| See examples of drillthrough queries for specific model types. | Data Mining Queries |
| Enable drillthrough in the Mining Model Wizard. | Completing the Wizard (Data Mining Wizard) |