Allow Office Scripts to refresh Power Query queries. It'd be very helpful to automatically refresh data using Power Automate, but that platform cannot currently refresh data.10 votes
Thank you for providing the feedback. Your input helps us in making the product better.
Reg. Power Query refresh action – yes, this is in our backlog. We don’t yet have an API that can refresh a Power Query. We’re working with the product team to prioritize the API. I don’t have an ETA yet. But, we’ll be monitoring this closely and update our docs once the feature becomes available. Feel free to email me if you need more details.
I understand getting full blown VBA working on the web is extremely unlikely (impossible?).
So - make Office Scripts run on native Excel (and other Office apps). That way we get
1) One common development language across all Microsoft Office applications
Thank you for sending Microsoft feedback. Your input is valuable to us and helps improve our products.
We do intend to support Office Scripts across other platforms and hosts. However, the priority and schedules for such expansion in coverage is not yet finalized. We are right now focussed on delivering it for Online platform with Power Automation support. Please stay tuned for future announcements to learn about the coverage.
- Don't see your idea?