hello,
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
Keep up to date with current events and community announcements in the Power Automate community.
Community Calls Conversations
A great place where you can stay up to date with community calls and interact with the speakers.
| User | Count |
|---|---|
| 51 | |
| 29 | |
| 29 | |
| 24 | |
| 22 |
