Here’s how to disable load in Power BI [EASY GUIDE]

3 min. read

Updated onOctober 4, 2023

updated onOctober 4, 2023

Share this article

Improve this guide

Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more

There are instances in whichPower BIuses a lot ofmemory, especially when it comes to old PCs. So, to minimizememoryand alsoCPU usage, it is crucial to disable certain queries.

By default, all queries load in the Query Editor. Today we will show you how to disable this function.

For quite a few users, this is a major issue, as one usersaid on the official forum:

What I am trying to buildup is appending 10 individual queries together (10 excel files, regularly updated on the sharepoint) into 1 table, which is than going to be loaded into the report. I do not need those 10 source files to be loaded as I will not buildup any visuals around those. Therefore I thought unchecking “Enable load to report” field in the Query Properties and keeping the “Include in report refresh” checked would work. What I found out is that the second checkbox is always automatically unchecked when I try to disable the load to report option. This would basically mean thatdatawon’t refresh at all in my opinion, right?

So, the OP can’t uncheckEnable load to reportbox while checkingInclude in report refreshbox. However, the issue can be solved quickly.

Steps to disable load in Power BI

This problem affects only the current query and the option to disable the load is found in the query pane, not in the query properties.

Working in Power BI will be like a walk in the park after reading this guide!

Conclusion

Disabling the load for queries is simpler than it seems. Make sure you don’t use that query in any of your visualizations.

If you do, it will automatically remove the query once you uncheck theEnable loadoption.

Did you find our method useful? Do let us know in the comments section below.

Here’s how to disable load in Power BI [EASY GUIDE]#

Steps to disable load in Power BI#

Conclusion#

Here’s how to disable load in Power BI [EASY GUIDE]

Steps to disable load in Power BI

Conclusion