Here we can see, “Here’s How to Disable Load in Power Bi”
Power BI occasionally consumes a significant amount of RAM, especially on older PCs. To reduce memory and CPU utilization, it is essential to disable some queries.
Every query loads by default in the Query Editor. We’ll demonstrate today how to turn off this feature.
This is a significant problem for many users, as one user noted 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 that data won’t refresh at all in my opinion, right?
The OP cannot uncheck the Include in the report refresh box while also ticking the Enable load to report box. The problem can be readily resolved, though.
Steps to disable load in Power BI
This issue impacts only the current query, and the query pane rather than the query attributes is where you can prevent the load.
-
- Click on Edit Queries. It’ll bring up a new window.
- Right-click your query (in this case, “Sales”) there, and then select “Enable load.”
- Disabling load will delete the table from the report and break any visualizations that use its columns, according to a notice box that will appear. Since you won’t be using the data in any visualizations, this won’t be an issue, so click Continue.
- The Enable load option is not chosen, and the query will now appear in italic type.
Conclusion
I hope you found this guide useful. If you’ve got any questions or comments, don’t hesitate to use the shape below.
User Questions
1. How can I halt the loading of Power BI?
It is possible to enable or disable whether a table is loaded into the report in Power BI Power Query. By right-clicking on the table, you can access the menu item “Enable load.” Usually, the load is already activated by default.
2. How can I stop Power Query from loading?
-
- Activate Power Query.
- Select File > Options.
- Visit the Global area.
- Select Data Load.
- Select the option to specify a custom load.
- De-select both.
3. How does Power BI enable load work?
When you click the “Refresh” button on the ribbon, the query is automatically renewed if “Include In Report Refresh” is checked. The report builder can access query results if “Enable Load” is selected. Otherwise, you may use it in other queries (for instance, to merge data), but the report builder does not display it.
4. If I disable Load in the Query, will my Appended table auto …
If I disable Load in the Query, will my Appended table auto refresh please? from PowerBI
5. Uncheck Enable Load : r/PowerBI – Reddit
