I'm importing data in 3 different tables and using that table data, I've created Pivot Tables. When I click on "Refresh All" its refresh pivot tables first and import fresh data later. This result in to Pivot table showing same data instead of updated table data as they are refreshing before query import data from external sources. Because of this sequence of refresh I've to click again on "Refresh All" button to update Pivot data. If user can manage the sequence of refreshing Tables & data (First let query import all data & later Pivot Table refresh data) so that user don't have to Click on "Refresh All" multiple times to get fresh data in all Tables/Pivot.

It took us three months for Microsoft support to understand this simple request and conclude it is a "functional limitation" with current Excel and the linking of data only works on local c-drive, not over a shared onedrive folder between colleagues - sigh.

Here is the summary of steps:

1. Open an Excel file.


2. Click on Data.


3. Click on get Data.


4. Select from File.


5. Select From Workbook.


6. Imports an Excel workbook which has table inside it and load it to this file.


7. Once done, upload it to OneDrive from where this files gets to be shared.


8. Go to Shared tab for OneDrive Online and then select Shared with me and then open a folder inside which the same file is saved using Excel application.


9. Select sync option to sync that to his pc and then opens the same file from his pc


10. Once file is open by another user, right click on the table from the excel sheet


11. Click on refresh from the menu and this is the point where you encounter the error.

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.

1. Guys, why you call every previous step for every next step in Power Query, while refreshing this query preview? I.e. if I am at Get&Transform UI and click "Refresh Preview" on a Query where I have 3 steps, PQ calls step one 3 times, and step two 2 times. But if you call step one, you can use the results of the call for the next step AND for showing its result in the UI as well. Why you call previous steps so much??




2. Moreover, you inevitably call all the Queries, used in the refreshing query from p.1. So in the case above, if refreshable query calls other query (let's call it PrevQuery), you call PrevQuery 3 times! And this is for every Query in a chain... It just throwing a lot of time of your users who do not want to lose the benefits of working with your really cool UI.

It is not possible to prevent querying the whole query chain using Table.Buffer. But it would be great if you would use the result of call of previous queries in a chain while working in PQ UI, i.e. in preview mode.

Please make the Power Query editor window (Get Data) non-model. When building complex queries, we often need to go back to Excel to change a worksheet and look at data. Right now, the Power Query editor window takes control over the application, preventing interaction with Excel.

The current behaviour makes it very difficult to do things like the following:
-Mid query, go back and check a worksheet to see exactly what a cell value may be that you want to refer to
-When we have a static table in Excel and are trying to build a query that lands an output in that shape, we can't hop back and forth and check how close we are

In the current implementation, we must close & load the query, check what we need, then re-open the query. Alternately we need to take a screen shot of the needed, or open a second Excel process in order to allow interaction. None of these are good solutions.