Forum Discussion

Alirezam's avatar
Alirezam
Helper V
5 years ago

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.