Change the Properties of a Mining Model
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.
Some mining model properties apply to the model as a whole, and other model properties apply to individual columns. Examples of properties that apply to the entire model would be the Drillthrough property, which specifies whether the case data should be available for querying, and the Description property. Properties that apply to the column include Usage and ModelingFlags, which control how data in the column is used within the model.
The following model properties have advanced editors that you can use to create expressions or configure complex model properties. The following properties provide:
Filter property: Opens the Data Set Filter or Model Filter Dialog Box.
AlgorithmParameters property: Opens the Algorithm Parameters Dialog Box (Mining Models View).
For information about how to set the properties in a mining model, see Mining Model Columns.
To change the properties of a mining model
In the Mining Models tab in Data Mining Designer, right-click either the column header that contains the name of the mining model, or the row in the grid that contains the name of the mining algorithm, and then select Properties.
In the Properties window on the right side of the screen, highlight the value that corresponds to the property that you want to change, and enter the new value.
The new value will take effect when you select a different element in the designer.
To change the properties of a mining model column
In the Mining Models tab in Data Mining Designer, right-click the cell in the grid at the intersection of the mining structure column and the mining model, and then select Properties.
In the Properties window on the right side of the screen, highlight the value that corresponds to the property that you want to change, and enter the new value.
Note
If the column usage is set to Ignore, the Properties window for the column is blank.
The new value will take effect when you select a different element in the designer.