After installing the most recent Power Query update, we can no longer refresh all of our queries simultaneously using Refresh All. 

We have a data model where data is being pulled from a single Excel spreadsheet into Power Query, than a few transformations take place and that data is then loaded into Power Pivot.  After installing the most recent Power Query update, the Refresh All option in Power Pivot or Excel does not work.  It begins the process of refreshing, but it goes into an endless refresh cycle (that never completes).  We are able to refresh the Power Pivot tables or the Power Query tables one by one, but not all at once.

I am certain that this issue relates to the most recent update to Power Query, for I tested the refresh on a machine that did not have the most recent Power Query update and it worked fine.  Then I updated Power Query and the Refresh All option stopped working.

Do you anyone have any suggestions on how to resolve this issue?

Hi David R Knopf,

Based on your description, you have test this issue in your environment. And you said I tested the refresh on a machine that did not have the most recent Power Query update and it worked fine. With your test, this issue might be caused by update. But we didnt get any other similar issues till now.

So I suggest you to Control Panel to check the version of your Power Query for excel, you can get the version number. Then you could post the version number to us. We can help you to find which update KB corresponds to the version of Power Query.

If you need further assistance with Power Query, I suggest you post your issue to Power Query forum.

https://social.technet.microsoft.com/Forums/office/en-US/home?forum=powerquery

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

Hope its helpful.

Regards,

George Zhao
TechNet Community Support

George,

Thank you for your response.

My version of Power Query is 2.21.3974.242.

Hi David R Knopf,

Based on the version of your Power Query, its not the latest version. I suggest you to upgrade your Power Query to the latest version 2.22.4007.242

And you can download from this link:

http://www.microsoft.com/en-US/download/details.aspx?id=39379

After upgrading it, please check if the issue is solved.

Hope its helpful.

Regards,

George Zhao
TechNet Community Support