Forum Discussion
Excel Online – Refresh Power Query – Failed -- Help
I have an Excel file that I wand to be able to do a Data -> Refresh All Connections to update a very simple Power Query script. I have 4 Excel Sheets and a simple Table in each. I have a Power Query ...
In addition about error message. Excel for web currently could refresh external connections. These are PivotTable connections to Power BI dataset, data model or cache. They are all external.
If Excel tries to refresh Power Query it looks for external connection for it, finds nothing and returns such error.
At least that's my understanding.
it is interesting that they have Power Query online for other things but they don't at least have Power Query refresh for simple stuff for Excel Online.
Hope it's coming