I'm using Power Query to load 10 tables to the data model. I noticed that my workbook has a PivotCache count of 4. Is it normal for PowerPivot to generate multiple caches or have things gotten duplicated? Is there any way to find out which queries each cache relates to? If I try ThisWorkBook.PivotCaches(1).SourceData I get Run-Time Error 1004 (Application or Object Defined Error).
Just wanting to make sure it isn't negatively impacting the file size or performance.
Thanks
Just wanting to make sure it isn't negatively impacting the file size or performance.
Thanks