Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
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,
Are you querying the folder that the file is in, as opposed to just the file directly?
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.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.