analysis services pivot taking a long time to refresh

Tina Douglass 1 Reputation point
2024-04-24T14:37:25.1533333+00:00

We have an analysis services object that we connect in excel for pivot tables. This has been running fine for 3 years. IN the past month it is taking very long to refresh and also prevents anything else in Excel from being opened (even outlook). What has changed?

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,249 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Tina Douglass 1 Reputation point
    2024-04-25T10:46:05.7133333+00:00

    Yes that is correct. It also makes other excel and outlook unusable. Once refresh does complete any drilling or selection of slicers triggers it again. That may have happened before but with longer time makes them unusable.