Showing results for 
Search instead for 
Did you mean: 
New Member

Power Query Can't be Refreshed In Excel Web



On SharePoint, I have a .xlsm Excel file containing Power Queries that connected to another Excel (.xlxs) file on SharePoint. The queries can be refreshed if opened in Excel Desktop (1st pic is one of the query for example). But if I open it in Excel Web, the queries can't be refreshed anymore (2nd pic).  


Why the power query is not working in Excel Web, and is there a way to fix it?


P.S. I need to create a Excel Web script of Refresh All, such that I can run this script in Power Automate Cloud flow.


Thank you!


One of my Power Query:


Not working in Excel Web:



Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,922)