Forum Discussion

Brass Contributor

Feb 16, 2024

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, ...

excel

Excel for web

SergeiBaklan
Feb 16, 2024
James_Price

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.

SergeiBaklan

Diamond Contributor

Feb 16, 2024

James_Price

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.

James_Price

Brass Contributor

Feb 16, 2024

Thanks SergeiBaklan. Considering this feature was created almost 2 years ago it's very disappointing it hasn't progressed.

James

SergeiBaklan
Diamond Contributor
Feb 17, 2024
James_Price

James, hope it will be coming soon, quite demanded feature.