Forum Discussion
Data Connection Refresh Error
You cannot refresh Power Query queries in Excel for the Web today (same applies for Teams which uses Excel for the Web internally). We are working on this, but it will take a while until we get there.
I encourage you to follow the announcements at the Excel blogs channel here on this portal:
Excel Blog - Microsoft Tech Community
Guy
- Excel Team
Guy Hunkin- Would you be willing to respond to this inquiry to let us know if this problem has been resolved since you posted about it in December 2020. I'm having a hard time refreshing a query via ExcelOnline or in Excel under the Teams wrapper. (Manually or via OfficeScript)
Only works if I open the workbook.
Thank you.
- Paul_CastelinoApr 14, 2022Copper Contributor
BCH78 No updates from Microsoft. Switched over to Google Sheets and it was simple and seamless....lol...
- ConnorMurphyApr 11, 2022Copper Contributor
BCH78 Don't hold ya breath! lol