<div>
Valid recommendations and reading material relevant to problem provided to author
</div>


<div>
<div class="content wysiwyg-content">
I have an Excel workbook with multiple pivot tables all using the same SSAS connection. &nbsp;When the users refresh the pivots, they have to enter credentials multiple times - once for each pivot. Is there any way around this that does not involve storing credentials in the connection string?
</div>
</div>


I have an Excel workbook with multiple pivot tables all using the same SSAS connection.  When the users refresh the pivots, they have to enter credentials multiple times - once for each pivot. Is there any way around this that does not involve storing credentials in the connection string?

SSAS Cube Refresh in Excel requires log in for every pivot

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL Server Analysis Services (SSAS) is an online analytical processing (OLAP) and data mining tool in Microsoft SQL Server used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files. Analysis Services includes a group of OLAP and data mining capabilities and comes in two flavors - Multidimensional and Tabular.