none
Power Query Update Issues RRS feed

  • Question

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

    Friday, May 8, 2015 8:05 PM

Answers

  • Hi David,

    Would you be able to send a frown from Power Query, so that we can take a look at your queries and environment?

    Also, to isolate the problem, you could try to disable "Refresh this connection on Refresh All" on each Power Query connection to see if there is a particular connection that is causing the issue.

    Finally, on the machine where this works, do you know what version of Power Query it is running?

    Thanks.

    Monday, May 11, 2015 11:28 PM