Analyze a Tabular Model in Excel (SSAS Tabular)
Applies To: SQL Server 2016
The Analyze in Excel feature in SQL Server Data Tools (SSDT) opens Microsoft Excel, creates a data source connection to the model workspace database, and adds a PivotTable to the worksheet. Model objects (tables, columns, measures, hierarchies, and KPIs) are included as fields in the PivotTable field list.
In SQL Server Data Tools, click the Model menu, and then click Analyze in Excel.
In the Choose Credential and Perspective dialog box, select one of the following credential options to connect to the model workspace data source:
To use the current user account, select Current Windows User.
To use a different user account, select Other Windows User.
Typically, this user account will be a member of a role. No password is required. The account can only be used in the context of an Excel connection to the workspace database.
To use a security role, select Role, and then in the listbox, select one or more roles.
Security roles must be defined using the Role Manager. For more information, see Create and Manage Roles (SSAS Tabular).
To use a perspective, in the Perspective listbox, select a perspective.
Perspectives (other than default) must be defined using the Perspectives dialog box. For more information, see Create and Manage Perspectives (SSAS Tabular).