Make a Copy 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.
Creating a copy of a mining model is useful when you want to quickly create several mining models that are based on the same data. After you copy the model, you can then edit the new copy by changing parameters or adding a filter.
For example, if you have a Customers table that is linked to a table of purchases, you could create copies to generate separate mining models for each customer demographic, filtering on attributes such as age or region.
For information about how to copy the content of the model (such as the graphical representation or the model patterns) to the Clipboard for use in other programs, see Copy a View of a Mining Model.
To create a related mining model
In SQL Server Data Tools, in Solution Explorer, click the mining structure that contains the mining model.
Click the Mining Models tab.
Select the model, and right-click to open the shortcut menu.
-or-
Select the model. On the Mining Model menu, select New Mining Model.
Type a name for the new mining model, and select an algorithm. Click OK.
To edit the filter on the copied mining model
Select the mining model.
In the Properties window, click the text box for the Filter property, and the click the build (...) button.
Change the filter conditions.
For more information about how to use the filter editor dialog boxes, see Apply a Filter to a Mining Model.
In the Properties window, in the AlgorithmParameters text box, click Setalgorithm parameters, and change algorithm parameters, if desired.
Click OK.
See Also
Filters for Mining Models (Analysis Services - Data Mining)
Mining Model Tasks and How-tos
Delete a Filter from a Mining Model