Bad performance updating Pivottables

[natasja]

I have created below model. Sales-data containes 600K rows, Dcalender 750 rows, Item info 1700 rows, Customer info 2000 rows, and remaining dimension tables app 25 rows.
2 calculated columns in DCalender, all other calculations have been created with DAX measures or M language custom columns.
I tested refresh All data both in Excel 32 and 64 bit, but no difference in performance is noted.
Loading the data only takes 60 seconds, but it takes app 12 minutes to refresh the pivot tables.
All queries are waiting for other data model queries.

Application Excel 365
There are 7 sheets, in total 20 Pivot tables, no slicers are applied. When I applied a slicer it slowed down the overall performance.
Privacy settings are disables, fast load enabled, background data disabled.

Can anyone please advise what am I doing wrong ?

Many thanks in advance for your support.
KR - natasja

 

[Matt Allington]

Pivot tables take time to refresh. Slicers will definitely make it worse, but if you turn of visual indication of values, they won’t take any more time. what takes a lot of the time is rendering the tables. How many data points do you have in total (tables x columns x rows). The bigger this number, the slower it is going to be. It’s easy to test. Take a copy of the workbook, delete all but 1 pivot and see how long it takes.