Forum Discussion

ovetteabejuela's avatar
ovetteabejuela
Impactful Individual
4 years ago

Power Query (Excel) Resource Hog

Why is power query eating up SO MUCH resources - I am not even refreshing anything I have just the Excel file open nothing is being refreshed,

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Are you querying the folder that the file is in, as opposed to just the file directly? 

    • ovetteabejuela's avatar
      ovetteabejuela
      Impactful Individual
      4 years ago

      Yes, in that workbook I have queries that point to folders (or files in a folder) and some that are directed to the files itself.

      Is that what is causing it and why. Also, is there a proper way to do it or how should we stop it from acting that way - using resources even if it's not being refresh.