Hi everybody,
I think I'm alright with Excel but this one bewilders me - I've googled to no avail what are the generic requirements for external data to be refresh-able in Excel Online...
OK, I create in installed Excel a pivot query that points to external data - be that other xl file or SQL server or what have you - the point is that it's a Power Query ListoObject pointing to some external data.
In the installed Excel version it obviously works - I can refresh the data whenever I want but if I open the same file in Excel Online and try to refresh all - always fires this error:
"External Data Refresh failed
We were unable to refresh one or more data connections in this workbook.
The following connections failed to refresh:"
RefreshFailed.jpg

And the 'Refresh Selected Connection' in the Ribbon is always greyed out.
Whenever I read on Msoft site or others it seems like the refresh should work also in Excel Online but surely there are some general requirements that I simply haven't fulfilled and therefore I cannot refresh the PQ there.
Any indications what I should check to enable refreshing in Excel Online?
Much appreciated.