Jan 23 2020 05:21 AM - edited Jan 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:
Jan 24 2020 08:57 AM
Dec 20 2020 08:37 PM
Jan 24 2021 01:36 PM