Forum Discussion
Alirezam
5 years agoHelper V
Extremely slow query when processing a query
Hi, I am reading multiple folders and process some xml. files in the power query editor. After adding a 'column' to calculate something, it is now taking few hours to load the query and apply the ne...
mahoneypat
5 years agoMicrosoft Employee
Please see this video and article. You are going to want to use Table.Buffer to avoid reloading your source data repeatedly.
(5) Inside Power Query reference queries for Power BI and Excel - YouTube
Power Query M Primer (Part 12): Tables—Table Think I | Ben Gribaudo
Pat
Alirezam
5 years agoHelper V
Thanks, it was helpful however did not solve my issue with slowness.