Forum Discussion
Data Connection Refresh Error
Hi. I have successfully been able to import data (in File No. 1) from another excel file (File No. 2). Both these files are stored in Sharepoint and are collaborated with a team. These files also can...
Guy Hunkin
Microsoft
Microsoft
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
Hello! See it has just been over a year since this comment was posted. I was curious if there has been any update regarding this matter? I am also trying to use the power query function in Teams and would love to be able to.
- Guy HunkinHi ConnorMurphy! It is a complicated project hence the progress is slow. But the work is in progress!
If you followed the news, you have probably noticed that we released a new Queries side pane in Excel for the Web where you can view the queries in your workbook with some additional metadata like the last refresh date and etc. More functionality is coming soon. Here is the link to the latest announcement for you convenience:
https://techcommunity.microsoft.com/t5/excel-blog/what-s-new-in-excel-for-the-web-december-2021/ba-p/3035350
Guy.
