Edit

Project properties

  • Article

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

Each tabular model project has deployment options and deployment server properties that specify how the project and model is deployed. For example, the server the model will be deployed to and the deployed model database name. These settings are different from model properties, which affect the model workspace database. The project properties described here are in a modal properties dialog box, different from the properties window used to display other types of properties. To display the modal project properties, in SQL Server Data Tools, in Solution Explorer, right-click the project, and then click Properties.

Project properties

Deployment Options

Property Default setting Description
Processing Option Default By default, Analysis Services will determine the type of processing required when changes to objects are deployed. This generally results in the fastest deployment time. However, you can also choose to have either full processing or no processing performed with each deployment.
Transactional Deployment False Specifies whether or not the deployment of the model is transactional. By default, the deployment of all or changed objects is not transactional with the processing of those deployed objects. Deployment can succeed and persist even though processing fails. You can change this to incorporate deployment and processing in a single transaction.
Query Mode In-Memory Specifies the source from which query results are returned. For more information, see DirectQuery Mode.

Deployment Server

Property Default setting Description
Server localhost Specifies an instance of Analysis Services. By default, models are deployed to the default instance of Analysis Services on the local computer. You can change this setting to specify a named instance on the local computer or any instance on any remote computer on which you have permission to create Analysis Services objects. Typically, Administrator permissions.

The default setting for this property can be changed using the Default Deployment Server property on the Deployment page in Analysis Server settings in the Tools\Options dialog box. For more information, see Configure default data modeling and deployment properties.
Edition Developer Specifies the edition of the Analysis Services server to which the model will be deployed. The server edition defines various features that can be incorporated into the project.
Database Model Specifies the name of the Analysis Services database in which model objects will be instantiated upon deployment. This name will be specified in a data connection or an .rsds data connection file. It is recommended the name reflect the type of analysis that will be performed using the model, for example AdventureWorksSalesModel.

To prevent duplicate names for deployed models, you should change the Database property name setting to reflect the purpose of the model. When users connect to the model as a data source, this is the name they will see.
Cube Name Model Specifies the name of the database cube as shown in a reporting client data connection.
Version 13.0 Version of the Analysis Services instance where the project will be deployed.

DirectQuery Options

Property Default setting Description
Impersonation Settings Default Specifies the credentials used to connect to data sources for a model running in DirectQuery Mode. These credentials are different from impersonation credentials that are used in the default In-Memory mode. For more information, see Impersonation.

Configure Deployment Options and Deployment Server property settings

  1. In SQL Server Data Tools, in Solution Explorer, right-click the project, and then click Properties.

  2. In the Properties window, click a property, and then type a value or click the down arrow to select a setting option.

See Also

Configure default data modeling and deployment properties
Model properties
Tabular model solution deployment