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 new steps. It is weird that as shown below, it looks like it is reading a massive file with over 1 GB but my data source is not bigger than 200 MB. Any idea would be appreciated.
2 Replies
- mahoneypatMicrosoft 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
- AlirezamHelper V
Thanks, it was helpful however did not solve my issue with slowness.