Forum Discussion
Solved
Power query load failure in Excel online...
Hi team
In Excel desktop, I created a power query linking a Excel file in a SP site in another tenant. I can refresh the data in the desktop but get an error when I try to do this in Excel Online, stating this is not supported yet.
Does anyone know when this feature will be supported (as I can't understand why it hasn't been fixed by now).
Many thanks
James
I may only repeat comments to this blog https://techcommunity.microsoft.com/t5/excel-blog/new-in-excel-for-the-web-power-query-refresh-is-now-generally/ba-p/3300369/page/2#comments
So far Power Query in Excel for web refreshes only anonymous sources, i.e. same workbook and some OData. As for the timeline, as usually Microsoft answers - stay tuned for updates.
3 Replies
I may only repeat comments to this blog https://techcommunity.microsoft.com/t5/excel-blog/new-in-excel-for-the-web-power-query-refresh-is-now-generally/ba-p/3300369/page/2#comments
So far Power Query in Excel for web refreshes only anonymous sources, i.e. same workbook and some OData. As for the timeline, as usually Microsoft answers - stay tuned for updates.
Thanks SergeiBaklan. Considering this feature was created almost 2 years ago it's very disappointing it hasn't progressed.
James
James, hope it will be coming soon, quite demanded feature.
