Having used the newfangled Queries and Connections pane for some time now I find it is time to add some suggestions

My issues:

1. 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.




2. 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.




3. It isn't application-centric
   If I open a new workbook with connections, the taskpane disappears




4. 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.




5. No "All" category
   I'd like an "All" category to pick from rather than either connections, OR Queries (and make that choice stick please)




6. Refresh button unavailable
   If the taskpane is too narrow (or phrased differently: if it isn't rediculously wide) the small refresh button is unavailable.




7. 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?




8. No Fly-out for connections
   Pity Old-school connections don't have the fly-out. No doubt something useful could be done with that.

PowerQuery is one of the best improvements added to current EXCEL! When importing data from almost all relevant sources, I can undo each single step of data-Import or transformation, even in non-temporal order.
BUT: if i drop a hole query, delete a table or something that is not in the steps list, or if i delete a step: this cannot be undone.
Please allow UNDO for
deleting queries
deleting steps
changing steps
(not adding wrong steps, this can be undone with deleting the step)

This would be a very great improvement! Today i deleted a query with many, many steps that was not safed before, so I had to re-do my work...

Thanks
Peter

It would be awesome if "Power BI Service" is added as a data source under "Get Data" in "Get & Transform Data" in Excel. Though the source availability is already there with "Power BI Publisher Add-in" but it is buggy and hard to deploy on large number of laptops/desktops. Also, it is practically very difficult to educate down the line users about re-enabling this add-in via COM Add-ins in case it disappears from the ribbon which is very frequent in case of this add-in. We have been struggling with this for a long period of time now.

Considering "Power BI Service" as a data source is already available inside Power BI Desktop, this should not be a big challenge for developers to bring the same inside "Get & Transform Data" in Excel.

If Power BI Service as a data source comes to Excel, it will lead to the following incredible benefits:

1. There will not be any need for Publisher Add-in for users who just want to access the dataset sitting in Power BI Service via Excel.




2. Simplification of landscape leading to further affirmation of "Excel and Power BI are better together" tagline which is frequently used by Microsoft.




3. No need to train users on installing publisher add-in in 1000s of laptops and desktops.




4. Nil technical support and maintenance because add-in itself is not required.




5. An incentive for big organizations to move to Excel 2016 due to Power BI Service integration within excel without any need to deploy add-in which is so buggy.




6. Win-win situation for both Microsoft and the clients, as Microsoft will get sales boost in terms of upgrade of Office and clients will save cost on deployment of Publisher add-in, related technical support and user training on installing and using Power BI Publisher.

This is such a low hanging fruit for Microsoft that it should be given priority.