Forum Discussion

Copper Contributor

May 18, 2020

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

excel

Guy Hunkin

Microsoft

Dec 01, 2020

Paul_Castelino

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

dgr4it

Iron Contributor

Dec 07, 2020

Guy Hunkin
Just wanted to say that I have the same problem as the OP (meaning I'd like the same feature).
I understand it's not working yet, hope you can get it soon.

One of the cool usages I've always thought I'd want Teams Excel tabs to be is displaying "simple dashboards" based on Excel files. I guess there are smarter ways of doing that, but as of now we tend to build those using self-refreshing Queries (not even Power Query, just simple Excel to Excel Queries).

Not being able to refresh those in Teams means the idea of the "simple dashboard" just fell into pieces.