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

jokahati

Microsoft

Apr 26, 2022

Hey all,
We appreciate your patience!
I can share we have now released the ability to refresh Power Query queries in Excel Web / Teams, for 2 data sources: From Table/Range and (anonymous) OData feed.
We are continuing work to support more data sources and refresh automation - stay tuned...
Happy for any feedback.

Mike2022615
Copper Contributor
Sep 07, 2022
Is it updated for excel source
- jokahati
  Microsoft
  Sep 07, 2022
  Hey Mike,
  
  Check this page: https://aka.ms/pqxlo
Mike2022615
Copper Contributor
Sep 07, 2022
jokahati Hi can you show me how
Anthony13122
Copper Contributor
May 17, 2022
jokahati Any update on supporting the Power Query data source for Excel Online?
"UNSUPPORTED DATA SOURCE This workbook contains Power Query queries that can't be refreshed in Excel for the Web."
- jokahati
  Microsoft
  May 17, 2022
  Hey Anthony13122,
  
  See my previous comment - we now support PQ Refresh in Excel Online for these data sources:
  From Table/Range and (anonymous) OData feed (also appears in the "Learn more" link).
  We are continuing work to support PQ Refresh for many more data sources.