Forum Discussion

Paul_Castelino's avatar
Paul_Castelino
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's avatar
Guy Hunkin
Icon for Microsoft rankMicrosoft
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

  • BCH78's avatar
    BCH78
    Copper Contributor
    Apr 10, 2022

    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_Castelino's avatar
      Paul_Castelino
      Copper Contributor
      Apr 14, 2022

      BCH78 No updates from Microsoft. Switched over to Google Sheets and it was simple and seamless....lol...

    • ConnorMurphy's avatar
      ConnorMurphy
      Copper Contributor
      Apr 11, 2022

      BCH78 Don't hold ya breath! lol

  • ConnorMurphy's avatar
    ConnorMurphy
    Copper Contributor
    Dec 15, 2021
    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.
  • dgr4it's avatar
    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.

Resources