01-23-2020 05:21 AM - edited 01-23-2020 05:22 AM
I have an excel with 25 pivot tables loaded from Power BI dataset using single connection . All pivot table contain 700 rows and maximum of 15 columns, And also having extra calculated columns from the pivot table values. While adding extra pivot tables(from same connection) to this existing workbook , I am facing incremental slowness (from 10 minutes to 20 m,30 m ,1 hr etc ) in new pivot tables loading when applying filters or dragging fields . Currently any of the pivot table is not even refreshing after hours and hours!!.
My workbook structure:
01-24-2020 08:57 AM
12-20-2020 08:37 PM