Power Query No Longer Refreshes Data Sources in Excel 2016

[Sean]

Since updating to Excel 2016 - Power Query no longer refreshes my data sources in any of my Excel files!

All those files were fine just couple days ago - before the Excel 2016 update...

Wow - Did I update Excel too early - Anyone else have this problem?

I tried to update just Power Query - but since its built in Excel 2016 it won't let you install just the newest Power Query.

PBI Desktop refreshes the same sources just fine and all pbix files are fine.

[Sean · Accepted solution]

Well after giving me the same message you see above for about 2 hours - it seems the problem has gone away and the refresh is back working! No idea what happened.

[Sean]

Well here we go again - another error when refreshing sources with Power Query in Excel 2016.

I only added 6 rows of new data in one of my data sources.

Again PBI Desktop refreshes the same source with no problem and all pbix reports work fine.

However I still have a few reports that are in Excel based on the same data because I can embed a spreadsheet on a webpage.

Power Query in Excel won't update...