Forum Discussion
Slow Processing - Get and Transform Data
When I use PivotTables created from data connections, without the folder with the data table, the query becomes extremely slow. My laptop is a DELL with Intel Core I7 16MB RAM, good equipment. Has anyone encountered the same problem?
1 Reply
Hi Marcelo,
I don't think your hardware is the bottleneck. Most probably that's how your queries are designed. There are lot of discussions about PQ/G&T performance, here is one of the links from my bookmarks https://social.technet.microsoft.com/Forums/en-US/0da5045e-7f8d-4ddb-8931-ef9c27543447/power-query-large-file-performance?forum=powerquery just to give an idea where the issue could be. Among others.
