Forum Discussion
Paul_Castelino
May 18, 2020Copper Contributor
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
Dec 01, 2020
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
ConnorMurphy
Dec 15, 2021Copper Contributor
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 HunkinDec 20, 2021
Microsoft
Hi 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.- SergeiBaklanDec 20, 2021Diamond Contributor