Avatar of JLEmlet

asked on 

SSAS Cube Refresh in Excel requires log in for every pivot

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?
Microsoft ExcelMicrosoft SQL ServerSSAS

Avatar of undefined
Last Comment
Anastasia D. Gavanas

8/22/2022 - Mon