Forum Discussion
Key board short cut - enable/disable load
What's the keyboard short cut for this? if I select a group of queries and I don't want to load them, is there a easier way than right-click on each and uncheck enable load?
is there such thing?
Hi peterhui50 ,
What's the keyboard short cut for this?
By default, "Enable load" option of all queries will be checked. Therefore all queries from Query Editor will be loaded into the memory of Power BI Model. If we disable the option "Enable Load" for one query, when we apply the change, this query table data will not be loaded to data model. But when we refresh the dataset, there is also a query sent to data source. This is important when your model grows big, especially disabling the option of queries that used as intermediate transformation to produce the final query for the model.
Reference: Performance Tip for Power BI; Enable Load Sucks Memory Up - RADACAD
if I select a group of queries and I don't want to load them, is there a easier way than right-click on each and uncheck enable load?is there such thing?
Based on my test, it is not supported to disable the option of a group queries at one time. It is needed to disable that option one by one.
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
2 Replies
Hi peterhui50 ,
What's the keyboard short cut for this?
By default, "Enable load" option of all queries will be checked. Therefore all queries from Query Editor will be loaded into the memory of Power BI Model. If we disable the option "Enable Load" for one query, when we apply the change, this query table data will not be loaded to data model. But when we refresh the dataset, there is also a query sent to data source. This is important when your model grows big, especially disabling the option of queries that used as intermediate transformation to produce the final query for the model.
Reference: Performance Tip for Power BI; Enable Load Sucks Memory Up - RADACAD
if I select a group of queries and I don't want to load them, is there a easier way than right-click on each and uncheck enable load?is there such thing?
Based on my test, it is not supported to disable the option of a group queries at one time. It is needed to disable that option one by one.
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
There is no shortcut but you might add the Home -> Properties menu item to the quick access ribon with [ALT] you can then access it quite easy still some tabs and clicks.
It then becomes
-arrow up or arrow down
-hit [SPACE] bar
-[ALT] + number of the quick access bar
-double [TAB]-[SPACE]
-[TAB]
-double [ENTER]
but now the disapointment... there is abug if you go this way it will not make the text of the query italicso take your mouse 🙂
