Power Query: Add all possible actions to context menu for multi-selected queries
In the Queries list of any Power Query window, the following actions are only available in the context menu when a single query is selected:
- Enable load
- Duplicate
- Reference
- Move up
- Move down
There's no apparent reason why these actions can't be applied to multiple queries in the same manner as the Copy, Paste, Delete, and Move to group actions, all of which appear in the context menu when multiple queries are selected.
Please add these missing actions to the multi-selected queries context menu in Power Query!
13 Comments
- Agreed. It is time-consuming to disable loading of queries one by one. It would be an improvement to have the option to Enable/Disable Load or Include/Exclude in Report Refresh multiple reports at once, such as within the right-click menu after selecting multiple reports through Ctrl/Shift + Click.
- moreover, a similar option is available in Power Query - Specify custom load settings
- AlexPowers
Microsoft Employee
I like it. Take my vote!
Agree!
- AlexPowers
You're speaking to my soul with this one, take all my votes!
- Ability to create connection only queries like you can using the Excel Power Query version So for a query in Power BI desktop ability to disable load to report but enable query refresh (the latter is automatically disabled when you disable the first)
HI,
Usually when I bring in multiple queries on to power query and would like to disable the "Enable Load" feature for each query, I would have to do it one by one. Can I simply select multiple queries, right click and hit Enable load to either disable or enable the load in bulk?
- Often I've got an entire query group of "intermediate" queries that I don't want loaded. It would be great if I could mark a group as "Do not load", or change the default setting of "Enable Load"
- It could be allowed to select multiple tables and enable/disable the options "Enable load" and "Include in report refresh". This would increase productivity when there are many table to work with.
Right now, if you want to create a query reference or enable/disable loading for a query you have to do it for each query individually. Please add the ability to select multiple queries and then perform an action, such as create a reference or toggle the load status for each query selected.
