Improve Queries and Connections Task Pane
Having used the newfangled Queries and Connections pane for some time now I find it is time to add some suggestions
The pane does not remember its size
It opens really narrow on my system, displaying only a (very) small part of the connection and query names so my first action every friggin time is to drag it wider.
No multi select
in the old connections window you can control or shift-click multiple connections to delete them. For maintenance this is a very useful feature I miss regularly.
It isn't application-centric
If I open a new workbook with connections, the taskpane disappears
No (or bad) short-cut key support
There seems to be no way to get the focus on the taskpane using the keyboard. F6 supposedly switches between the worksheet, ribbon, task pane, and Zoom controls but there is no way to tell if the taskpane has the focus as far as I could figure out.
No "All" category
I'd like an "All" category to pick from rather than either connections, OR Queries (and make that choice stick please)
Refresh button unavailable
If the taskpane is too narrow (or phrased differently: if it isn't rediculously wide) the small refresh button is unavailable.
Refresh is not on the fly-out
Why isn't there a refresh button on the fly-out pane when you hover over a connection/query?
No Fly-out for connections
Pity Old-school connections don't have the fly-out. No doubt something useful could be done with that.
Thank you for showing passion for Power Query and various improvements! We are indeed looking to implement some of these suggestions.
In general, we’re evaluating our future investments and your votes help us to prioritize. Please keep voting if you like these ideas.
[PM @ Excel]
Ken Puls commented
Also, drag and drop to re-order queries in this pane is sorely needed.
Josh N commented
A painpoint for me with this pane is the lack of a clear sorting mechanism within query groups. It doesn't seem to be alphabetical, based on count-of-results, or based on when the query was added to the group
Ricardo Diaz commented
Another one: Show the last elpased time it took each query to refresh
Karen Price commented
One more item please ... add the date/timestamp of the last refresh for the data connection. The previous Data Connections window had this right there so you could see it quickly and then hit the Refresh button, all in the same window. The new panel must have a timestamp and a refresh button to improve it's usefulness.
Ken Puls commented
An additional item I would like is to disable the flyouts for data previews. If you ave a big query that is pretty intensive, accidentally pausing on it to trigger the fly out can cause Excel to focus on the refresh and consume resources.